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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppgsql-committers @
categoriespostgresql
postedJun 24, '13 at 7:14p
activeJun 28, '13 at 11:28p
posts2
users1
websitepostgresql.org...
irc#postgresql

1 user in discussion

Simon Riggs: 2 posts

People

Translate

site design / logo © 2017 Grokbase