BUG #4727: Unable to drop table for cache lookup failed for relation

From: "lorenzo" <l(dot)bolzani(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4727: Unable to drop table for cache lookup failed for relation
Date: 2009-03-24 15:30:06
Message-ID: 200903241530.n2OFU60A079181@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4727
Logged by: lorenzo
Email address: l(dot)bolzani(at)gmail(dot)com
PostgreSQL version: 8.3.6
Operating system: Windows Server 2003 R2 SP2
Description: Unable to drop table for cache lookup failed for
relation
Details:

Hi,
I am unable to drop a table receiving this error

ERROR: cache lookup failed for relation 925244

This also blocks the schema drop so the only solution is to drop the whole
database. This is not the first time it happened.
We are working with hibernate in drop-create mode, so the tables are dropped
and recreated several times a day, from 4 different workstations (one
hundred times a day or more).

I have a saved copy of the database. Please let me know how I can provide
help to fix this problem.

Thanks, bye

Lorenzo

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-03-24 15:38:41 Re: BUG #4727: Unable to drop table for cache lookup failed for relation
Previous Message Tom Lane 2009-03-23 14:19:52 Re: BUG #4726: pg_dumpall -f doesn't report error when file can't be opened