Re: [GENERAL] Multiple key error . - Mailing list pgsql-general

From Szymon Lipiński
Subject Re: [GENERAL] Multiple key error .
Date
Msg-id CAFjNrYso4rKvRcJarcDfL9qEb6fsVzLaPOt8=xuTcJ2V1Ug+hw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Multiple key error .  (Brahmam Eswar <brahmam1234@gmail.com>)
Responses Re: [GENERAL] Multiple key error .  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
On 23 November 2017 at 12:31, Brahmam Eswar wrote: > Unable to add multiple keys to the table. > > ALTER TABLE table1 ADD CONSTRAINT Table1_PK PRIMARY KEY (Col1,Col2); > > ERROR: multiple primary keys for table "table1" are not allowed > SQL state: 42P16 > > -- > Thanks & Regards, > Brahmeswara Rao J. > Hey, table can have only one primary key. And most probably you already have one. regards, Szymon Lipiński

pgsql-general by date:

Previous
From: Brahmam Eswar
Date:
Subject: [GENERAL] Multiple key error .
Next
From: Geoff Winkless
Date:
Subject: Re: [GENERAL] Multiple key error .