Skip site navigation (1) Skip section navigation (2)

Re: ERROR: cache lookup failed for relation NNNNN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: cache lookup failed for relation NNNNN
Date: 2008-09-25 04:27:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
"Ridvan Lakas ng Bayan S. Baluyos" <ridvan(at)baluyos(dot)net> writes:
> I'm having a problem dropping a schema. It displays the following errors:

> pos=# drop schema store_survey cascade;
> ERROR:  cache lookup failed for relation 9026446

If you're on 8.2.not-the-latest or 8.3.not-the-latest, this is probably
a known bug.  Update.

			regards, tom lane

2008-07-11 12:08  tgl

	* src/backend/catalog/: dependency.c (REL8_3_STABLE), dependency.c
	(REL8_2_STABLE): Fix an oversight in the original implementation of
	performMultipleDeletions(): the alreadyDeleted list has to be
	passed down through deleteDependentObjects(), else objects that are
	deleted via auto/internal dependencies don't get reported back up
	to performMultipleDeletions().	Depending on the visitation order,
	this could cause the code to try to delete an already-deleted
	object, leading to strange errors in DROP OWNED (typically "cache
	lookup failed for relation NNNNN" or similar).	Per bug #4289.
	Patch for back branches only.  This code has recently been
	rewritten in HEAD, and doesn't have this particular bug anymore.

In response to

pgsql-novice by date

Next:From: Mike EllsworthDate: 2008-09-25 11:54:05
Subject: Packaged solution (Dump partial Schema?)
Previous:From: Ridvan Lakas ng Bayan S. BaluyosDate: 2008-09-25 04:10:59
Subject: ERROR: cache lookup failed for relation NNNNN

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group