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.
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
On 23 November 2017 at 11:37, Szymon Lipiński <mabewlun@gmail.com> wrote:
> table can have only one primary key. And most probably you already have one.
To clarify, you can have multiple UNIQUE constraints on a table, but
only one PRIMARY.
Geoff