On 5/19/06, Tom Lane <[EMAIL PROTECTED]> wrote:
This only affects the 7.4 and 8.0 branches, because earlier and later versions of Postgres don't use this technique for detecting duplicates. But it's surprising we didn't find it before.
hm. about a year ago I reported a case where the database allowed multiple records with the same p-key which were causing problems with dump/reload from 8.0->8.1. It was pretty rare, but it looked like under certain circumstances unique constraint was not getting applied. I was unable to reproduce it, though. Is it possible that this bug was the cause of that particular problem? Merlin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
