Horton
Menu

Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update

Pavan Deolasee <pavan.deolasee@gmail.com>

View thread
From: Pavan Deolasee <pavan.deolasee@gmail.com>
To: Andres Freund <andres@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-11-27T11:23:21Z
Lists: pgsql-hackers 
On Tue, Nov 27, 2012 at 4:49 PM, Andres Freund <andres@2ndquadrant.com>wrote:

> On 2012-11-27 16:39:58 +0530, Pavan Deolasee wrote:
>
> > >
> > There might be a bug there as you are suggesting, but for me the CREATE
> > INDEX itself fails (and rightly so) because of duplicate keys. Do I need
> to
> > run these statements in different sessions ?
>
> Sure, the CREATE INDEX fails. The point is that we successfully can
> create the foreign key afterwards anyway.
>
>
Ah OK. Got it.

Thanks,
Pavan