Skip site navigation (1) Skip section navigation (2)

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-0006GL-TH@gemulon.postgresql.org (view raw or flat)
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
------
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(-)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group