]> granicus.if.org Git - postgresql/commit
ALTER TABLE ... ALTER CONSTRAINT for FKs
authorSimon Riggs <simon@2ndQuadrant.com>
Fri, 28 Jun 2013 23:27:30 +0000 (00:27 +0100)
committerSimon Riggs <simon@2ndQuadrant.com>
Fri, 28 Jun 2013 23:27:30 +0000 (00:27 +0100)
commitf177cbfe676dc2c7ca2b206c54d6bf819feeea8b
tree00b7869b96efdafac8623134af2c35a31c3995f5
parent2f74e4ec50dc625605e9a7afd63bd8a48c981d9e
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
doc/src/sgml/ref/alter_table.sgml
src/backend/commands/tablecmds.c
src/backend/parser/gram.y
src/include/nodes/parsenodes.h
src/test/regress/expected/foreign_key.out
src/test/regress/sql/foreign_key.sql