Re: Recreate primary key without dropping foreign keys?

Поиск
Список
Период
Сортировка
От Chris Ernst
Тема Re: Recreate primary key without dropping foreign keys?
Дата
Msg-id 4F8CDB95.3040407@zvelo.com
обсуждение исходный текст
Ответ на Re: Recreate primary key without dropping foreign keys?  (amador alvarez <aalvarez@d2.com>)
Ответы Re: Recreate primary key without dropping foreign keys?  (Igor Neyman <ineyman@perceptron.com>)
Список pgsql-admin
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: amador alvarez
Дата:
Сообщение: Re: Recreate primary key without dropping foreign keys?
Следующее
От: videanuadrian
Дата:
Сообщение: Re: How to auto swtich the roles of primary and standby