Re: How to temporarily disable a table's FK constraints? - Mailing list pgsql-general

From Kynn Jones
Subject Re: How to temporarily disable a table's FK constraints?
Date
Msg-id c2350ba40711060503y12685325g93691d4e17455778@mail.gmail.com
Whole thread Raw
In response to Re: How to temporarily disable a table's FK constraints?  (andy <andy@squeakycode.net>)
List pgsql-general
On 11/5/07, andy <andy@squeakycode.net> wrote:
> Hey, I was just thinking about this... instead of disabling the FK's,
> what about adding a temp table where you could COPY into, then fire off
> a bunch of update's to setup the id fields, etc, etc, then do an Insert
> into realtable select * from temptable?

I like this idea.  It's very straightforward.  Thanks!

kj

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: generic crosstab
Next
From: "Albe Laurenz"
Date:
Subject: Re: How to create primary key