Re: [GENERAL] Multiple key error .

From: Szymon Lipiński <mabewlun(at)gmail(dot)com>
To: Brahmam Eswar <brahmam1234(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Multiple key error .
Date: 2017-11-23 11:37:30
Message-ID: CAFjNrYso4rKvRcJarcDfL9qEb6fsVzLaPOt8=xuTcJ2V1Ug+hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 23 November 2017 at 12:31, Brahmam Eswar <brahmam1234(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2017-11-23 11:39:05 Re: [GENERAL] Multiple key error .
Previous Message Brahmam Eswar 2017-11-23 11:31:13 [GENERAL] Multiple key error .