Re: PostgreSQL 8.1.0 catalog corruption

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bob Ippolito <bob(at)redivi(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1.0 catalog corruption
Date: 2005-11-21 21:43:23
Message-ID: 4469.1132609403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bob Ippolito <bob(at)redivi(dot)com> writes:
> I don't know how to get the oid of a type.. but there are certainly
> entries in pg_depend with the other criteria:

Hmph, looks like you still have a pretty full set of dependencies for
the table. What about attributes --- try
select attname from pg_attribute where attrelid = 211174567;

It might be interesting to try reindexing pg_class, too ... maybe the
pg_class row is still there but isn't being found because of a corrupt
index?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-21 21:44:36 Re: MERGE vs REPLACE
Previous Message Peter Eisentraut 2005-11-21 21:40:40 Re: Data directory on read-only media