From b577a57d4113bcbd1a7900b78b3e41df528c9a35 Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Mon, 24 Jun 2013 20:07:41 +0100 Subject: 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 | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 7ee0aa8ca07..2609d4a8eaf 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -46,6 +46,7 @@ ALTER TABLE [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ADD table_constraint [ NOT VALID ] ADD table_constraint_using_index + ALTER CONSTRAINT constraint_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] VALIDATE CONSTRAINT constraint_name DROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ] DISABLE TRIGGER [ trigger_name | ALL | USER ] @@ -316,6 +317,16 @@ ALTER TABLE [ IF EXISTS ] name + + ALTER CONSTRAINT + + + This form alters the attributes of a constraint that was previously + created. Currently only foreign key constraints may be altered. + + + + VALIDATE CONSTRAINT -- cgit v1.2.3