Re: Disable and enable of table and column constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Disable and enable of table and column constraints
Date: 2009-09-08 19:23:15
Message-ID: 15314.1252437795@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-09-08 20:07:20 Re: Disable and enable of table and column constraints
Previous Message Robert Haas 2009-09-08 19:22:22 Re: Time-based Releases WAS: 8.5 release timetable, again