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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
