>
>Theory: Could it be that the index is ok, but that pg_class is corrupted.   This
>is based on the earlier observation that shows the most recent inserts and
>updated no being appended to the end of the table.

No, I don't think so, when a table gets "lost" there are more entries in the 2 indices
than in the pg_class table itself. If I do a vacuum analyze it sais 167 entries in pg_class
200 entries in pg_class_relname_index and pg_class_oid_index.

Andreas



Wed, 9 Sep 1998 09:13:52 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
AW: [HACKERS] index fix report