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

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update
Date: 2012-11-27 11:23:21
Message-ID: CABOikdPOFzTTYr_wnZge1BBSa_LrD4kbCtxShfg-FQs0wTRPpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 27, 2012 at 4:49 PM, Andres Freund <andres(at)2ndquadrant(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit kapila 2012-11-27 12:52:15 Re: Review: Patch to compute Max LSN of Data Pages
Previous Message Pavan Deolasee 2012-11-27 11:19:50 Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update