Re: Multiple key error .

[Szymon Lipiński <mabewlun@xxxxxxxxx>]

On 23 November 2017 at 12:31, Brahmam Eswar <brahmam1234@xxxxxxxxx> 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