Postgres Pro
Downloads
Home   >   mailing lists

Re: Disable foreign key constraints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Disable foreign key constraints
Date
Msg-id 14857.1028229592@sss.pgh.pa.us
Whole thread Raw
In response to Disable foreign key constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Disable foreign key constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Do we have any way to disable foreign key constraints?

You can drop and re-add the constraint relatively painlessly in 7.3.
Formerly it took hacking on pg_trigger.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Trimming the Fat, Part Deux ...
Next
From: Bruce Momjian
Date:
Subject: Re: Disable foreign key constraints