Re: [SQL] how to add primary key to existing table with multiple primary keys

: viernes, 24 febrero, 2006 2:45Para: pgsql-sql@postgresql.orgAsunto: [SQL] how to add primary key to existing table with multiple primary keys Hi there,   I am trying to add another primary key to an existing table with two other primary keys.  I got the following error when I tried

[SQL] how to add primary key to existing table with multiple primary keys

Hi there,   I am trying to add another primary key to an existing table with two other primary keys.  I got the following error when I tried this command:   alter table extprobe2tissue ADD primary key (expid); ERROR:  multiple primary keys for table "extprobe2tissue" are not allowed