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/f177cbfe676dc2c7ca2b206c54d6bf819feeea8b

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 11 +++
src/backend/commands/tablecmds.c | 139 +++++++++++++++++++++++++++++
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, 205 insertions(+)

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 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