Fw: Removing foreign key and adding sequence

Поиск
Список
Период
Сортировка
От Chad Thompson
Тема Fw: Removing foreign key and adding sequence
Дата
Msg-id 001b01c33c08$62070ce0$32021aac@chad
обсуждение исходный текст
Ответы Re: Fw: Removing foreign key and adding sequence  (Nabil Sayegh <postgresql@e-trolley.de>)
Список pgsql-novice
 > Chad,
 >
 > > alter table lists rename to lists_bak;
 > >
 > > select * from lists_bak into lists;
 > >
 > > I can add the constraints and foreign key's back in that ARE necessary,
 my
 > > only worry (and mabey you can think of another worry) is that my
 sequence
 > > is no longer attached to the id field of my table.
 > >
 > > Is this the right approach, and if so, how do I add my sequence back
in?
 >
 > Simple:  when you re-create Lists, just make sure that the id is "DEFAULT
 > NEXTVAL('sequence_name')".  That's it.  Sequences are easy.

The id is a foreign key on other tables, so I dont want to reorder the
table.  You're saying that I wouldn't reorder if I did it this way?

 >
 > However, I think it might be easier just to drop the FKs.  What version
 are
 > you using?
 >


 7.32.  Can I just drop the foreign key?  That would be SO much easier :-)

Thanks
Chad


В списке pgsql-novice по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Removing foreign key and adding sequence
Следующее
От: Nabil Sayegh
Дата:
Сообщение: Re: Fw: Removing foreign key and adding sequence