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 12277 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: diff_views(): need to...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
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)

12272 02/17/2014 11:05 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_set_search_path(VARIADIC schemas text[])

12271 02/17/2014 10:54 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_use_own_schema()

12270 02/17/2014 10:52 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_set_search_path()

12269 02/17/2014 10:17 AM Aaron Marcuse-Kubitza

schemas/util.sql: use builtin string_agg(..., ) instead of concat()

12268 02/17/2014 12:34 AM Aaron Marcuse-Kubitza

schemas/util.sql: added qual_name(type unknown) to avoid needing to explicitly specify the type of an input string

View all revisions | View revisions

Also available in: Atom