From: Bradley Holbrook <operations_bradley@servillian.ca>
To: pgsql-admin@postgresql.org
Subject: Drop Schema Error
Date: Fri, 28 Jan 2011 15:53:59 -0800
Message-ID: <00fe01cbbf46$a1c21c20$e5465460$@servillian.ca> (raw)
Hello!
I'm trying to:
DROP SCHEMA "_old_permissions";
And I get this error:
ERROR: cannot drop schema _old_permissions because other objects depend on
it
DETAIL: function 17059 depends on schema _old_permissions
function 17060 depends on schema _old_permissions
HINT: Use DROP . CASCADE to drop the dependant objects too.
So, naturally I:
DROP SCHEMA "_old_permissions" CASCADE;
Which produces:
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?
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: operations_bradley@servillian.ca
Subject: Re: Drop Schema Error
In-Reply-To: <00fe01cbbf46$a1c21c20$e5465460$@servillian.ca>
* 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