Postgres Pro
Downloads
Home   >   mailing lists

Re: Recreate primary key without dropping foreign keys? - Mailing list pgsql-admin

From Chris Ernst
Subject Re: Recreate primary key without dropping foreign keys?
Date
Msg-id 4F8CDB95.3040407@zvelo.com
Whole thread Raw
In response to Re: Recreate primary key without dropping foreign keys?  (amador alvarez <aalvarez@d2.com>)
Responses Re: Recreate primary key without dropping foreign keys?  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-admin
Tree view 
On 04/16/2012 07:02 PM, amador alvarez wrote:
> How about deferring the FK's while recreating the PK ?
> or using a temporary parallel table to be pointed by the other tables
> (FK) and swap it up on the recreation.

Hmm.. Interesting.   But it appears that you have to declare the foreign
key as deferrable at creation.  Is there any way to set an existing
foreign key as deferrable?

    - Chris

pgsql-admin by date:

Previous
From: amador alvarez
Date:
Subject: Re: Recreate primary key without dropping foreign keys?
Next
From: videanuadrian
Date:
Subject: Re: How to auto swtich the roles of primary and standby