Re: BUG #4913: Row missing from primary key index - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #4913: Row missing from primary key index
Date
Msg-id 87r5wpcsal.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #4913: Row missing from primary key index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 >> The system was recently dump/restored from a different box. The
 >> failing rows are all new inserts since the restore.

 Tom> So the table has been insert-only so far?  I was just thinking
 Tom> that HOT bugs seemed like a probable explanation, but that idea
 Tom> goes out the window if there have been no UPDATEs.

No UPDATEs (and there are no HOT flags set on any tuple I looked at).
There may have been DELETEs.

--
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #4913: Row missing from primary key index
Next
From: "Dan Boeriu"
Date:
Subject: BUG #4914: uuid_generate_v4 not present in either source or yum/rpm