Re: Relation does not exist

<p><font size="2">> "Brusser, Michael" <Michael.Brusser@matrixone.com> writes:</font><br /><font size="2">>
>Our customer reported a problem with Postgres v.7.3.2 </font><br /><font size="2">> server on Solaris
8</font><br/><font size="2">> > I asked them to run a quick query and it looks like the database is</font><br
/><fontsize="2">> > corrupted:</font><br /><font size="2">> </font><br /><font size="2">> > select count
(1)from t_revisioncontrol</font><br /><font size="2">> > ERROR: Relation 17236 does not exist</font><br /><font
size="2">></font><br /><font size="2">> If you are lucky, the problem is just one of corrupted indexes
on</font><br/><font size="2">> the system catalogs (most likely pg_class_oid_index) and can be fixed</font><br
/><fontsize="2">> by REINDEXing.</font><br /><font size="2">> </font><br /><font size="2">> What happened to
leadup to this?  Usually this sort of thing doesn't</font><br /><font size="2">> appear out of the blue.  Any system
crashesor anything?</font><br /><font size="2">> </font><br /><font size="2">>                       regards, tom
lane</font><p><fontsize="2">All they said was that "they did not have power outage"</font><br /><font size="2">REINDEX
helped,many thanks!</font><p><font size="2">Mike.</font><br /><p><font size="2"> </font>