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
------
REL9_2_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/68043258ac54b09565e9bebadb16214d9b6df933
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(-)