in some sort of freak accident, we've ended up with a duplicated
record. all info, including the oid was duplicated.
it was during an update, two people ran a command at the same time.
user 1: BEGIN
user 1: NOTIFY
user 1: UPDATE
user 2: BEGIN
user 2: NOTIFY
user 1: END
user 2: UPDATE
user 2: END
same command, so the queries are the same. the record duplicated was
the one being updated. i'll try to reproduce it.
also, I had a unique index on the table, but that didn't seem to make
any ideas on how to delete one without deleting both?
pgsql-hackers by date
|Next:||From: Brett McCormick||Date: 1998-07-15 03:57:55|
|Subject: more on phantom record|
|Previous:||From: Bruce Momjian||Date: 1998-07-15 03:48:23|
|Subject: Re: [HACKERS] "internal error" triggered by EXISTS()|