]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Change syntax of new CHECK NO INHERIT constraints
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 24 Jul 2012 19:49:54 +0000 (15:49 -0400)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 24 Jul 2012 20:02:18 +0000 (16:02 -0400)
commit68043258ac54b09565e9bebadb16214d9b6df933
treeca768620b18500e517c8dfc82668650d027fab09
parentd86fb72c5c7ebf71e238ac87daa0c1f8043a1717
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.
12 files changed:
doc/src/sgml/ref/alter_table.sgml
doc/src/sgml/ref/create_table.sgml
doc/src/sgml/release-9.2.sgml
src/backend/commands/typecmds.c
src/backend/parser/gram.y
src/backend/utils/adt/ruleutils.c
src/test/regress/expected/alter_table.out
src/test/regress/expected/inherit.out
src/test/regress/input/constraints.source
src/test/regress/output/constraints.source
src/test/regress/sql/alter_table.sql
src/test/regress/sql/inherit.sql