[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] Deadlock during CREATE INDEX CONCURRENTLY, but index
From: Scott Marlowe <scott.marlowe () gmail ! com>
Date: 2011-05-18 15:33:17
Message-ID: BANLkTimKaXXjG6Ga5B+9=t5GtG5ofLUV2Q () mail ! gmail ! com
[Download RAW message or body]
On Wed, May 18, 2011 at 9:19 AM, Florian Weimer <fweimer@bfk.de> wrote:
> I've run two CREATE INDEX CONCURRENTLY on the same table in parallel,
> and one of them errored out with:
> The curious thing is that both indexes were created. I would have
> expected that the creation of idx1 would be rolled back.
>
> Are both of the usable, or should I re-create idx1 from scratch?
They should be marked invalid.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic