| 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-28 23:28:06 |
| Message-ID: | E1Usi5G-0005qa-5s@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | 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/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(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2013-06-28 23:59:52 | pgsql: Change errcode for lock_timeout to match NOWAIT |
| Previous Message | Bruce Momjian | 2013-06-28 23:11:56 | pgsql: pg_upgrade: pass username to analyze script |