On Tue, 2009-09-08 at 16:07 -0400, Alvaro Herrera wrote: > Tom Lane wrote: > > Michael Gould <mgo...@intermodalsoftwaresolutions.net> writes: > > > It would be nice if we could enable and disable column and table > > > constraints. I believe that you can do this in Oracle but this is very > > > handy for testing stored procedures and other external processes. > > > > Drop the constraint and re-add it later... > > That's not very useful when adding it later means grabbing an exclusive > lock on the table for the whole duration of the full table scan required > to check the table.
It's also useful to define foreign keys for documentation purposes but not enforce them for some reason. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
