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
|
Список | 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 по дате отправления: