delete/copy on table with foreign keys

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: delete/copy on table with foreign keys
Date: 2004-07-17 20:26:23
Message-ID: 20040717202623.85504.qmail@web52907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to disable "delete casade foreign keys"
so all items in a table can be deleted without the
items in the other tables being deleted as well? The
only thing I can figure out is maybe drop all relevant
triggers, delete, import (I'm trying to reimport data
on only one table), then recreate the triggers. set
constraints doesn't appear to fit the bill, nor
transactions. In the archives I saw mention of "alter
table disable|enable trigger ..." getting added to the
TODO.

CSN


__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/

Browse pgsql-general by date

  From Date Subject
Next Message Scrappy 2004-07-17 21:03:00 Re:
Previous Message Hervé Piedvache 2004-07-17 20:05:40 URGENT pg_xlog full impossible to restart ...