pgsql: Change syntax of new CHECK NO INHERIT constraints - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Change syntax of new CHECK NO INHERIT constraints
Date
Msg-id E1StlcU-0006GJ-Rh@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Change syntax of new CHECK NO INHERIT constraints

The initially implemented syntax, "CHECK NO INHERIT (expr)" was not
deemed very good, so switch to "CHECK (expr) NO INHERIT" instead.  This
way it looks similar to SQL-standards compliant constraint attribute.

Backport to 9.2 where the new syntax and feature was introduced.

Per discussion.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/d7b47e515530520da9564b05991bd8a8c6f52b06

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml          |    4 +-
doc/src/sgml/ref/create_table.sgml         |    6 +-
doc/src/sgml/release-9.2.sgml              |    2 +-
src/backend/commands/typecmds.c            |    8 +++-
src/backend/parser/gram.y                  |   58 +++++++++++++++++----------
src/backend/utils/adt/ruleutils.c          |    7 +--
src/test/regress/expected/alter_table.out  |   10 ++--
src/test/regress/expected/inherit.out      |    4 +-
src/test/regress/input/constraints.source  |    4 +-
src/test/regress/output/constraints.source |    4 +-
src/test/regress/sql/alter_table.sql       |    6 +-
src/test/regress/sql/inherit.sql           |    2 +-
12 files changed, 67 insertions(+), 48 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Update information schema to SQL:2011
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Change syntax of new CHECK NO INHERIT constraints