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

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

On Thu, 23 Feb 2006, Daniel Joo wrote: > 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: You only can have one primary key. The table you gave has a single primary key with two columns. Are you tr

[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