| 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
| 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 |