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(-)
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 |