Re: bug in 7.4 ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, eg(at)cybertec(dot)at
Subject: Re: bug in 7.4 ...
Date: 2003-11-11 14:36:17
Message-ID: 29987.1068561377@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)at> writes:
> I have seen that a bug related to duplicated keys is in 7.4rc2. As far
> as I have seen a bug like that has already been discovered during the
> 7.3 era. Is this bug going to be fixed?

We do not have, and never have had, deferred unique constraints, which
is what would be needed to make this UPDATE work safely. As-is, you
update the '5' entry to '4', and this fails if the '4' row hasn't been
updated yet, which depends on the order the rows happen to be visited
in.

It's on the TODO list but don't hold your breath ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-11-11 14:41:45 Re: bugzilla (Was: What do you want me to do?)
Previous Message Tom Lane 2003-11-11 14:18:48 Re: 7.4RC2 regression failur and not running stats collector process on Solaris