Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update
Date
Msg-id CABOikdPOFzTTYr_wnZge1BBSa_LrD4kbCtxShfg-FQs0wTRPpA@mail.gmail.com
Whole thread Raw
In response to Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view



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 

pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update
Next
From: Amit kapila
Date:
Subject: Re: Review: Patch to compute Max LSN of Data Pages