Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 14242 over 10 years Aaron Marcuse-Kubitza fix: schemas/util.sql: check_constraint_expr_di...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14242 07/21/2014 03:39 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: check_constraint_expr_disable(): need to use CASE instead of `true OR ` because OR always evaluates both sides, slowing down constraint evaluation

14241 07/21/2014 03:23 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: check_constraint view: conrelid: don't cast to regclass so can use index scan

14240 07/21/2014 03:21 AM Aaron Marcuse-Kubitza

bugfix: derived_col_constraint_initially_enabled(): use whether existing constraint is already enabled, not whether expr is unchanged (which does not affect the enabled status)

14239 07/21/2014 02:52 AM Aaron Marcuse-Kubitza

schemas/util.sql: check_constraint_canon_sql(): use util.debug_print_return_value() to assist debugging

14238 07/21/2014 02:49 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: check_constraint_replace(): need to use util.check_constraint_canon_sql() instead of util.canon_sql()

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

View all revisions | View revisions

Also available in: Atom