Re: add primary key doesn't block?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: add primary key doesn't block?
Date: 2010-01-21 17:45:14
Message-ID: 10570.1264095914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-01-21 21:00:06 Re: BUG #5294: Sorts on more than just the order-by clause
Previous Message Jaime Casanova 2010-01-21 17:38:56 add primary key doesn't block?