n->def = (Node *) c;

c->contype = CONSTR_FOREIGN;/* others not supported, yet*/

c->conname =$3;

processCASbits($4, @4,"ALTER CONSTRAINT statement",

processCASbits($4, @4,"FOREIGN KEY",

&c->deferrable,

&c->initdeferred,

NULL,NULL, yyscanner);

COMMIT;

-- try additional syntax

ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NOT DEFERRABLE;

-- illegaloption

-- illegaloptions

ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NOT DEFERRABLE INITIALLY DEFERRED;

ERROR: constraint declared INITIALLY DEFERRED must be DEFERRABLE

LINE 1: ...e ALTER CONSTRAINT fktable_fk_fkey NOT DEFERRABLE INITIALLY ...

^

ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NO INHERIT;

ERROR: FOREIGN KEY constraints cannot be marked NO INHERIT

ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NOT VALID;

ERROR: FOREIGN KEY constraints cannot be marked NOT VALID

-- test order of firing of FK triggers when several RI-induced changes need to

-- be made to the same row. This was broken by subtransaction-related

-- changes in 8.0.

ALTERTABLE fktable ALTERCONSTRAINT fktable_fk_fkey NOT DEFERRABLE;

ALTERTABLE fktable ALTERCONSTRAINT fktable_fk_fkey NOT DEFERRABLE INITIALLY DEFERRED;

ALTERTABLE fktable ALTERCONSTRAINT fktable_fk_fkey NO INHERIT;

ALTERTABLE fktable ALTERCONSTRAINT fktable_fk_fkey NOT VALID;