ALTER TABLE ... ALTER CONSTRAINT - Mailing list pgsql-hackers

From Simon Riggs
Subject ALTER TABLE ... ALTER CONSTRAINT
Date
Msg-id CA+U5nML4d_HJfp2+hcbYQcGA_Y30nxt+Yu-44KVtQgcSJB09+w@mail.gmail.com
Whole thread Raw
Responses Re: ALTER TABLE ... ALTER CONSTRAINT
Re: ALTER TABLE ... ALTER CONSTRAINT
List pgsql-hackers
While fiddling with FK tuning, it was useful to be able to enable and
disable the DEFERRED mode of constraints.

That is not currently possible in SQL, so I wrote this patch. Without
this you have to drop and then re-add a constraint, which is
impractical for large tables.

e.g.
CREATE TABLE fktable (id integer, fk integer REFERENCES pktable (id));

ALTER TABLE foo
   ALTER CONSTRAINT fktable_fk_fkey DEFERRED INITIALLY IMMEDIATE;

Includes docs and tests.

Currently works for FKs only. Potentially other constraints can be
supported in future.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Cost limited statements RFC
Next
From: Greg Smith
Date:
Subject: Re: Cost limited statements RFC