Mark CHECK constraints declared NOT VALID valid if created with table. FOREIGN KEY constraints have behaved this way for a long time, but for some reason the behavior of CHECK constraints has been inconsistent up until now.
Amit Langote and Amul Sul, with assorted tweaks by me. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/f27a6b15e6566fba7748d0d9a3fc5bcfd52c4a1b Modified Files -------------- src/backend/catalog/heap.c | 2 +- src/backend/parser/gram.y | 2 ++ src/backend/parser/parse_utilcmd.c | 45 +++++++++++++++++++++++++++-- src/test/regress/expected/alter_table.out | 11 ++++++- src/test/regress/sql/alter_table.sql | 5 +++- 5 files changed, 60 insertions(+), 5 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
