Re: PostgreSQL 8.1.0 catalog corruption

On Nov 21, 2005, at 1:43 PM, Tom Lane wrote:

> 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?

The attributes look like the names of all the columns in the table,
and reindexing didn't help.

mochi=# select attname from pg_attribute where attrelid = 211174567;
attname
------------------------
tableoid
cmax
xmax
cmin
xmin
oid
ctid
id
timestamp
ip_address
mochiTag
mochiGUID
mochiVersion
movieURL
movieURLHost
movieReferrer
movieReferrerHost
movieUserAgent
movieSWFVersion
movieBytesLoaded
movieQuality
movieStageHeight
movieStageWidth
movieBytesTotal
movieStageAlign
movieScaleMode
movieShowMenu
userScreenReader
userCameras
userMicrophones
userSystemCapabilities
userTimeZoneOffset
userTicks
userUTCTime
(34 rows)

mochi=# reindex table pg_class;
REINDEX
mochi=# create table ping_1132387200();
ERROR: type "ping_1132387200" already exists
mochi=# drop table ping_1132387200;
ERROR: table "ping_1132387200" does not exist
mochi=# drop type ping_1132387200;
ERROR: cache lookup failed for relation 211174567

-bob