On Nov 21, 2005, at 1:43 PM, Tom Lane wrote:
Bob Ippolito <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
