Re: [HACKERS] Relation does not exist
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.
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 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[HACKERS] Relation does not exist
Title: Relation does not exist 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 What can I do next? Thanks, Mike