Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> On Wed, 28 Apr 2004 09:33:34 +0100, Ben Young <ben(at)transversal(dot)com>
>> Is this [...] a known problem in Posgresql,
>> 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
In response to
pgsql-general by date
|Next:||From: Ben Young||Date: 2004-04-28 12:53:24|
|Subject: Re: Updates not atomic with respect to indexes|
|Previous:||From: Ian Ribas||Date: 2004-04-28 12:14:03|
|Subject: Re: Optimizer choosing smaller index instead of right one|