Re: Updates not atomic with respect to indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: Updates not atomic with respect to indexes
Date
Msg-id 27402.1083155871@sss.pgh.pa.us
Whole thread Raw
In response to Re: Updates not atomic with respect to indexes  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: Updates not atomic with respect to indexes
List pgsql-general
Manfred Koizar <mkoi-pg@aon.at> writes:
> On Wed, 28 Apr 2004 09:33:34 +0100, Ben Young <ben@transversal.com>
> wrote:
>> Is this [...] a known problem in Posgresql,
> Yes.
>> or bug which will be fixed sometime.
> Don't know.

I believe this is meant to be covered by this TODO item:

* Allow DEFERRABLE UNIQUE constraints

because the real issue is that the uniqueness check occurs immediately
rather than being deferred till end of statement or transaction.

Dunno when it will rise to the top of anyone's priority list...

            regards, tom lane

pgsql-general by date:

Previous
From: Ian Ribas
Date:
Subject: Re: Optimizer choosing smaller index instead of right one
Next
From: Ben Young
Date:
Subject: Re: Updates not atomic with respect to indexes