Re: Relation does not exist - Mailing list pgsql-hackers

From Brusser, Michael
Subject Re: Relation does not exist
Date
Msg-id 9150DCE0CCB4D411A7DB00508BB0DBF20B59D02D@msx1am.matrixone.net
Whole thread Raw
In response to Relation does not exist  ("Brusser, Michael" <Michael.Brusser@matrixone.com>)
List pgsql-hackers
<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> 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: SELECT MAX with char => BUG?
Next
From: "Katsaros Kwn/nos"
Date:
Subject: SRF related and other questions