Re: temporarily disabling foreign keys - Mailing list pgsql-general

From Vick Khera
Subject Re: temporarily disabling foreign keys
Date
Msg-id BANLkTimnBBp1Vm+d0P9seMiY9TXQJOXtDw@mail.gmail.com
Whole thread Raw
In response to temporarily disabling foreign keys  (Seb <spluque@gmail.com>)
List pgsql-general
in recent versions of postgres, there is a "replication" mode designed
specifically for replication software to disable FK's and other
triggers.  Perhaps investigate that.

the other option is to make your FK's deferrable, and do all your
delete in one big transaction with the FK checks deferred.  not sure
if that will help.

either that, or order your deletes and loads in a way such that the
FKs remain satisfied.  unless you have circular dependencies, this
should be possible.

pgsql-general by date:

Previous
From: Seb
Date:
Subject: temporarily disabling foreign keys
Next
From: John R Pierce
Date:
Subject: Re: temporarily disabling foreign keys