Re: temporarily disabling foreign keys

On Tue, 10 May 2011 14:29:48 -0400,
Vick Khera <vivek(at)khera(dot)org> wrote:

> 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.

Excellent, this last suggestion was actually a very simple and efficient
solution. However, I got curious about the deferrable FK's, which might
make this and other scripts more flexible.

Thanks everyone for your feedback,

--
Seb