On 1/6/06, Daniel Kunkel <DanielKunkel(at)biowaves(dot)com> wrote:
> Hi
>
> It makes sense that I can't have more than 1 primary key.
>
> Postgres was trying to create another primary key instead of modify the
> existing primary key.
>
> So...
>
> As I understand it, a table does not always have to have a primary key
> defined.
>
> Would it work to first delete/drop the primary key, then recreate the
> primary key on all 6 columns.
>
yes, but you have to drop all the dependant FOREIGN KEY constraints too
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)