| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Brusser, Michael" <Michael(dot)Brusser(at)matrixone(dot)com> |
| Cc: | "Pgsql-Hackers (E-mail)" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Relation does not exist |
| Date: | 2004-11-13 23:45:17 |
| Message-ID: | 3862.1100389517@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Hallgren | 2004-11-14 00:20:03 | Re: CVS should die |
| Previous Message | Gavin Sherry | 2004-11-13 12:14:28 | src/tools/make_keywords |