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

From Tom Lane
Subject Re: BUG #4913: Row missing from primary key index
Date
Msg-id 9857.1247183801@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4913: Row missing from primary key index  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: BUG #4913: Row missing from primary key index  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
>  Tom> One thing that seems odd is that the xids are kinda small.  Did
>  Tom> the system just recently have a wraparound event?

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

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

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #4913: Row missing from primary key index
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #4913: Row missing from primary key index