OID cache lookups failing

Admins; we have a few corrupt objects after a disk array event
yesterday.  One of the problems was resolved by simply dropping and
reloading a table from backup.

I have another table however that's going to b a stinker.  I can't
drop, rename or re-schema it.

We have 2 tabs with same name in different schemas and the active one
was being thrashed at the same time as the disk array went wonky.

Of particular interest, I notice that I can't get the pg_class record
that corresponds to the OID in question however the one for the other
version of the table does come up.


= drop table reports.problem_table;
ERROR:  cache lookup failed for relation 104140413


= select oid from pg_class where relname = 'problem_table';
    oid
-----------
     19296
 104140413
(2 rows)

= select relname from pg_class where oid in (select oid from pg_class where relname = 'problem_table');
        relname
-----------------------
 problem_table
(1 row)


The low numbered OID rec is the one showing above.

Any ideas how to fix?  This is on a busy prod system.  Reindexing
pg_class worth a try?

Thanks


--
-------------------------------------------------------------------------------
Jerry Sievers   305 854-3001 (home)     WWW ECommerce Consultant
                305 321-1144 (mobile    http://www.JerrySievers.com/