Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  branches 11969 over 10 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 over 10 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 12282 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: diff_any(): documented how to...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12282 02/17/2014 01:22 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff_any(): documented how to run EXPLAIN on the FULL JOIN query

12281 02/17/2014 01:19 PM Aaron Marcuse-Kubitza

schemas/util.sql: removed non-useful diff_queries() (it is not possible to match distinct `record` types to a common return type, so this would not have worked). use diff_views() instead.

12280 02/17/2014 01:14 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff_queries(), diff_views(): embed views verbatim as FROM items, so that the type of their corresponding columns is the view's rowtype. this is necessary in order to match the types of the columns to the return type (set by col_type_null).

12279 02/17/2014 12:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff_cols(): renamed to diff_queries() because multiple columns are supported

12278 02/17/2014 12:26 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff_cols(): don't assume that each side will have one column, as many of our validations queries have multiple columns

12277 02/17/2014 11:45 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff_views(): need to use $2, not $1, for the 2nd query

12276 02/17/2014 11:40 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: materialize_query(): remove any extra blank line before the query, to improve readability when newlines are used as a log message separator and are therefore confusing in the middle of a log message

12275 02/17/2014 11:37 AM Aaron Marcuse-Kubitza

schemas/util.sql: added ltrim_nl()

12274 02/17/2014 11:25 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: setting search_path locally: also need to set function option search_path, in order to limit the effects of `SET LOCAL search_path` (mk_set_search_path()) to the current function (http://www.postgresql.org/docs/9.1/static/sql-set.html#AEN75423)

12273 02/17/2014 11:14 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: setting search_path locally: need to use `SET LOCAL search_path TO` instead of `PERFORM set_config(search_path, ..., is_local := true)` because the meaning of is_local refers to the entire transaction, not just the current function (as for LOCAL)

View all revisions | View revisions

Also available in: Atom