Re: Relation does not exist

> "Brusser, Michael" <Michael(dot)Brusser(at)matrixone(dot)com> writes:
> > Our customer reported a problem with Postgres v.7.3.2
> server on Solaris 8
> > I asked them to run a quick query and it looks like the database is
> > corrupted:
>
> > select count (1) from t_revisioncontrol
> > ERROR: Relation 17236 does not exist
>
> If you are lucky, the problem is just one of corrupted indexes on
> the system catalogs (most likely pg_class_oid_index) and can be fixed
> by REINDEXing.
>
> What happened to lead up to this? Usually this sort of thing doesn't
> appear out of the blue. Any system crashes or anything?
>
> regards, tom lane

All they said was that "they did not have power outage"
REINDEX helped, many thanks!

Mike.