pgsql: ALTER TABLE ... ALTER CONSTRAINT for FKs

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: ALTER TABLE ... ALTER CONSTRAINT for FKs
Date: 2013-06-24 19:13:59
Message-ID: E1UrCD9-0000yI-1a@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

ALTER TABLE ... ALTER CONSTRAINT for FKs

Allow constraint attributes to be altered,
so the default setting of NOT DEFERRABLE
can be altered to DEFERRABLE and back.

Review by Abhijit Menon-Sen

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b577a57d4113bcbd1a7900b78b3e41df528c9a35

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 11 +++
src/backend/commands/tablecmds.c | 138 +++++++++++++++++++++++++++++
src/backend/parser/gram.y | 15 ++++
src/include/nodes/parsenodes.h | 1 +
src/test/regress/expected/foreign_key.out | 19 ++++
src/test/regress/sql/foreign_key.sql | 20 +++++
6 files changed, 204 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2013-06-24 20:22:01 pgsql: Reverting previous commit, pending investigation
Previous Message Peter Eisentraut 2013-06-24 18:56:47 pgsql: Stamp 9.3beta2.