Hi all,

I have the following problem in my testbed :

PostgreSQL version: 8.0
Operating system: Solaris 8.0
Description: Cache lookup failed.

I am running PostgreSQL ver. 8.0 with table space setup'ed for
CTBLISTDB.

\d command used to give the existing relations in the database.
But now it is saying :
ERROR : Cache lookup failed for relation 17233.
I could not able to proceed further. Any help ??

$ psql CTBLISTDB
Welcome to psql 8.0.0, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

CTBLISTDB=# \d
ERROR : Cache lookup failed for relation 17233


Thanks
Siva


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"Sivaraman K.G" <Ganapathy.Sivaraman (AT) alcatel (DOT) com> writes:
Not a lot of information to go on here. What do you get from

select * from pg_class where oid = 17233;

Can you do other operations besides \d?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

[quote=Tom Lane]"Sivaraman K.G" <Ganapathy.Sivaraman (AT) alcatel (DOT) com> writes:

Not a lot of information to go on here. What do you get from

select * from pg_class where oid = 17233;

Can you do other operations besides \d?

regards, tom lane
----------------------------------------------------

I had same problem with \d. when I select * from pg_class where oid = xxxxxx;
I got the following
DBName=# select * from pg_class where oid=986410890;
relname | relnamespace | reltype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | relhassubclass | relacl
------------+--------------+-----------+----------+-------+-------------+---------------+----------+------------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------
gtotap_tmp | 2200 | 986410891 | 100 | 0 | 986410890 | 0 | 347448 | 1.7985e+07 | 986410892 | 0 | f | f | r | 6 | 0 | 0 | 0 | 0 | 0 | t | f | f | f |
(1 row)


Is there way to recover the DB? what if I remove table "gtotap_tmp"? will it be recovered? However, I am still able to query the contents of the tables.

Thanks.