Fw: Removing foreign key and adding sequence

> 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