How to recover from : "Cache lookup failed for relation "
| От | Patrick.FICHE@AQSACOM.COM |
|---|---|
| Тема | How to recover from : "Cache lookup failed for relation " |
| Дата | |
| Msg-id | 1DC6C8C88D09D51181A40002A5286929B22FEE@intranet обсуждение исходный текст |
| Ответы |
Re: How to recover from : "Cache lookup failed for relation "
|
| Список | pgsql-general |
Hi,
I have a server installed with Postgres 8.0.2 on Solaris.
Since two days, I get the error : "ERROR: cache lookup failed for relation 463558"
When I look with the pgAdmin at my database, I see that I have in pg_temp_4 schema, a type called "tmp_d_alarm" which is the name of a temporary table that I'm using in functions....
The table of the same name is not in the schema and I suspect that this remaining type is causing the trouble.
How to get read of this type. I'm not able to drop it, neither the schema... I tried some REINDEX but it seems that nothing will remove this type....
Thanks for your help
Patrick
-------------------------------------------------------------------------------------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
-------------------------------------------------------------------------------------------
В списке pgsql-general по дате отправления: