Обсуждение: ERROR: cache lookup failed for relation NNNNN
Hi list,
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
pos=#
I already tried logging in as postgres user but still i'm receiving this error.
Thanks in advance!
Ridvan
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos
Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.
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
pos=#
I already tried logging in as postgres user but still i'm receiving this error.
Thanks in advance!
Ridvan
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos
Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.
"Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.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.