Re: Updates not atomic with respect to indexes

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