"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
: 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
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" 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
