Project

General

Profile

Statistics
| Revision:

root @ 14237

Name Size Revision Age Author Comment
  branches 11969 about 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 about 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 14237 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: added check_constraint_canon_...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14237 07/21/2014 02:40 AM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_canon_sql(). this must be used instead of plain util.canon_sql() because unlike queries, CHECK constraints are not simplified, just standardized.
14236 07/21/2014 02:06 AM Aaron Marcuse-Kubitza

schemas/util.sql: check_constraint_replace(): support not canon-ing def.expr
14235 07/21/2014 12:23 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: CHECK constraint exprs: need to remove the enclosing () to be consistent everywhere
14234 07/20/2014 11:59 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: canon_sql(): need to include the enclosing () because the DB includes them
14233 07/20/2014 11:42 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: canon_sql(): use explain()'s verbose mode to facilitate debugging
14232 07/20/2014 11:38 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: explain(): need to restore NOTICEs in verbose mode
14231 07/20/2014 11:22 PM Aaron Marcuse-Kubitza

schemas/util.sql: explain(): support running in verbose mode
14230 07/20/2014 11:19 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: check_constraint_replace(): need to canon the expr, using new util.canon_sql(), so it can be compared with the expr in the DB
14229 07/20/2014 11:18 PM Aaron Marcuse-Kubitza

schemas/util.sql: added canon_sql(expr text, table_ regclass)
14228 07/20/2014 10:45 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: check_constraint view: don't use pretty-print mode, because this format does not match util.canon_sql()

View all revisions | View revisions

Also available in: Atom