Postgres Pro
Downloads
Home   >   mailing lists

Re: Disable and enable of table and column constraints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Disable and enable of table and column constraints
Date
Msg-id 15314.1252437795@sss.pgh.pa.us
Whole thread Raw
In response to Disable and enable of table and column constraints  (Michael Gould <mgould@intermodalsoftwaresolutions.net>)
Responses Re: Disable and enable of table and column constraints
List pgsql-hackers
Tree view 
Michael Gould <mgould@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...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Time-based Releases WAS: 8.5 release timetable, again
Next
From: Alvaro Herrera
Date:
Subject: Re: Disable and enable of table and column constraints