temporarily disabling foreign keys

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: temporarily disabling foreign keys
Date: 2011-05-10 18:12:14
Message-ID: 874o52ctmp.fsf@kolob.subpolar.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm not sure how best to handle this situation. The tables in a
database need to be completely cleared and copy'ed into about every few
months, as they are updated with new records and corrections from a
provider. Because the tables have foreign key constraints with 'ON
UPDATE CASCADE ON DELETE RESTRICT', it's not possible to DELETE them
without violating these constraints. I've been dropping the constraints
while doing these transactions and then recreating them once everything
is done, but this has gotten tedious. Is there some way to "disable"
the foreign keys and enabling them after the transactions? Thanks.

Cheers,

--
Seb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2011-05-10 18:29:48 Re: temporarily disabling foreign keys
Previous Message Pavel Stehule 2011-05-10 16:28:36 Re: what is way to specify a DOCTYPE for output from SQL/XML