ALTER TABLE ... ALTER CONSTRAINT for FKs
Simon Riggs <simon@2ndQuadrant.com>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_table.sgml | modified | +11 −0 |
| src/backend/commands/tablecmds.c | modified | +138 −0 |
| src/backend/parser/gram.y | modified | +15 −0 |
| src/include/nodes/parsenodes.h | modified | +1 −0 |
| src/test/regress/expected/foreign_key.out | modified | +19 −0 |
| src/test/regress/sql/foreign_key.sql | modified | +20 −0 |