Title: RE: [HACKERS] Relation does not exist

> "Brusser, Michael" <[EMAIL PROTECTED]> 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.


 

Reply via email to