Re: add primary key doesn't block? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: add primary key doesn't block?
Date
Msg-id 10570.1264095914@sss.pgh.pa.us
Whole thread Raw
In response to add primary key doesn't block?  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: add primary key doesn't block?  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-bugs
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> When we perform a test migration of the data we found some errors on
> the logs, one of them is this one:

> """
> mic=# ALTER TABLE tcom_invitacion ADD primary key (id_invitacion);
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "tcom_invitacion_pkey" for table "tcom_invitacion"
> ERROR:  concurrent insert in progress
> """

Can you provide a reproducible test case?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: add primary key doesn't block?
Next
From: "Allen Johnson"
Date:
Subject: BUG #5294: Sorts on more than just the order-by clause