Обсуждение: pgsql: ALTER TABLE ... ALTER CONSTRAINT for FKs

Поиск
Список
Период
Сортировка

pgsql: ALTER TABLE ... ALTER CONSTRAINT for FKs

От
Simon Riggs
Дата:
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(+)