cache lookup failed for relation X

Поиск
Список
Период
Сортировка
От Dave Wurtz
Тема cache lookup failed for relation X
Дата
Msg-id 352858.14686.qm@web45908.mail.sp1.yahoo.com
обсуждение исходный текст
Список pgsql-general

I found some posts be developers discussing this issue last Jan. and Nov.. See link below.

http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation&l=&d=&s=

 

But have not been able to find any suggestion on how an end user can use to get around this problem.  Basically, we have a table X, trying to drop it would result an error message below:

 

cache lookup failed for relation XXXXX

 

I  am using PgAdmin  and I can still view the schema of this table, but any operation on it would get the above error.

 

Any suggestion on how to drop a table in this situation.

 

I am also wondering whether this problem has been fixed in newer PostgreSQL releases.

 

BTW, our postgreSQL version is 7.4.3.

 

Thanks.



Looking for last minute shopping deals? Find them fast with Yahoo! Search.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Wei Wu"
Дата:
Сообщение: cache lookup failed for relation X
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Watch your PlanetPostgreSQL.org blogs