Temporarily disable the triggers on that table and then re-enable them
afterwards. The trick is to set pg_class.reltriggers = 0 to disable and
then restore it to the correct number of triggers afterward. Play with
pg_restore or search the recent (last month) archives for more on this.
If you give pg_restore enough information it will disable triggers oduring
the load. You'd want to read that for an example of the correct SQL. Also,
I posted last month two functions to disable/enable all non-system
triggers in on swell foop. Look in the archives for that.

Joshua b. Jore
On Mon, 15 Apr 2002, Rob wrote:

Hi all,

I've got a column in one of my tables that references another column in
another table
i.e. barcode REFERENCES product(barcode)

Is there a way to drop this referential integrity for a while and then
reinstate it?


He who dies with the most toys ...

... still dies

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-novice @
postedApr 15, '02 at 8:01a
activeApr 15, '02 at 12:56p

2 users in discussion

Joshua b. Jore: 1 post Rob: 1 post



site design / logo © 2022 Grokbase