Re: Cannot create unique index - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot create unique index
Date
Msg-id 2892.1057069771@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cannot create unique index  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> how odd.  Since reindex works by dropping the index then recreating it, is
> it possible that some process inserted duplicates in the split second
> there was no index?

No, because reindex holds exclusive lock on the table for the whole
process.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pg_Dumpall error?
Next
From: Alejandro Javier Pomeraniec
Date:
Subject: Accent insensitive search