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