|
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. This communication may contain information that is confidential, privileged or subject to copyright. If you are not the intended recipient, please advise by return e-mail and delete the message and any attachments immediately without reading, copying or forwarding to others. |
