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
"Bradley Holbrook" 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
On Sat, Jan 29, 2011 at 5:57 PM, Tom Lane wrote:
> "Bradley Holbrook" 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 funct
: Bradley Holbrook; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Drop Schema Error
On Sat, Jan 29, 2011 at 5:57 PM, Tom Lane wrote:
"Bradley Holbrook" writes:
> DROP SCHEMA "_old_permissions" CASCADE;
> NOTICE: drop cascades to 2 other objects
> DETAI
"Bradley Holbrook" writes:
> I renamed the schema from permissions to _old_permissions and I believe this
> caused the error.
Uh, no, certainly not. pg_depend only cares about the objects' OIDs,
not their names. Testing in 8.3, it works fine:
regression=# create schema old_permissions;
CREATE