pgsql: Mark CHECK constraints declared NOT VALID valid if created with - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Mark CHECK constraints declared NOT VALID valid if created with
Date
Msg-id E1a9BU7-0007Ov-DO@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Stamp 9.5rc1.
Next
From: Robert Haas
Date:
Subject: pgsql: Speed up CREATE INDEX CONCURRENTLY's TID sort.