pgsql: Change syntax of new CHECK NO INHERIT constraints

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Change syntax of new CHECK NO INHERIT constraints
Date: 2012-07-24 20:22:14
Message-ID: E1StlcU-0006GJ-Rh@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2012-07-25 04:05:39 pgsql: Add translator comments to module names
Previous Message Peter Eisentraut 2012-07-23 19:33:12 pgsql: Update information schema to SQL:2011