Re: 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.

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

--
Josh Berkus
Aglio Database Solutions
San Francisco