From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bradley Holbrook <operations_bradley@servillian.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: Drop Schema Error
Date: Sat, 29 Jan 2011 11:57:55 -0500
Message-ID: <12066.1296320275@sss.pgh.pa.us> (raw)
In-Reply-To: <00fe01cbbf46$a1c21c20$e5465460$@servillian.ca>
References: <00fe01cbbf46$a1c21c20$e5465460$@servillian.ca>
"Bradley Holbrook" <operations_bradley@servillian.ca> writes:
> DROP SCHEMA "_old_permissions" CASCADE;
> NOTICE: drop cascades to 2 other objects
> DETAIL: drop cascades to function 17059
> drop cascades to function 17060
> [Err] ERROR: cache lookup failed for function 17060
> What is this trying to tell me?
Apparently you've got some dangling references in pg_depend, ie those
functions were dropped already but the pg_depend entries for them were
not cleaned up.
We've heard similar reports before (usually about temp tables not
functions, IIRC) but never been able to reproduce them or identify a
cause. What PG version is this? Have you done anything funny to that
schema or its contents, or had any crashes around the time of
manipulating either?
As far as cleaning up goes, the thing to do would be to manually delete
the relevant pg_depend entries --- for this one, an entry with objid =
17060 is probably what you're looking for. But it would be good to try
to figure out how you got into this state first.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, operations_bradley@servillian.ca
Subject: Re: Drop Schema Error
In-Reply-To: <12066.1296320275@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox