>>>>> "Tom" == Tom Lane <t...@sss.pgh.pa.us> writes:
> "Robert Treat" <xzi...@users.sourceforge.net> writes: >> PostgreSQL version: 8.3.1 >> Description: Corrupted pg_class, possibly truncate/rollback related Tom> FWIW, there is a bug fix in 8.3.4 addressing possible HOT-chain Tom> corruption after a REINDEX of pg_class. Not sure if that Tom> could've been the issue here. I asked Robert about that when we were discussing it on IRC, and he said that no such REINDEX had been done (and nor had ALTER TABLE RENAME and ALTER TABLE SET SCHEMA been done on the affected table). However I'm wondering if another 8.3.4 fix, the RecentGlobalXmin one, could be relevant here? http://archives.postgresql.org/pgsql-committers/2008-09/msg00105.php (I'm not seeing how it would be, but... note that the xids have got to the point that they'd appear to be in the past from the point of view of FirstNormalTransactionId) -- Andrew (irc:RhodiumToad) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs