Re: Recreate primary key without dropping foreign keys?

From: Chris Ernst <cernst(at)zvelo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Recreate primary key without dropping foreign keys?
Date: 2012-04-17 02:55:17
Message-ID: 4F8CDB95.3040407@zvelo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message videanuadrian 2012-04-17 05:42:50 Re: How to auto swtich the roles of primary and standby
Previous Message amador alvarez 2012-04-17 01:02:18 Re: Recreate primary key without dropping foreign keys?

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2012-04-17 08:22:36 Re: How to install pgfincore with PG 9.1
Previous Message Stephen Rees 2012-04-17 02:38:07 Advisory Locks and Prepared Transactions