Postgres Pro
Downloads
Home   >   mailing lists

How to recover from : "Cache lookup failed for relation " - Mailing list pgsql-general

From Patrick.FICHE@AQSACOM.COM
Subject How to recover from : "Cache lookup failed for relation "
Date
Msg-id 1DC6C8C88D09D51181A40002A5286929B22FEE@intranet
Whole thread Raw
Responses Re: How to recover from : "Cache lookup failed for relation "
List pgsql-general
Tree view
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 by date:

Previous
From: "Sim Zacks"
Date:
Subject: Re: double quotes inside VBA string ?
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: Postgresql 7.4.7 docs(PDF)