| From: | "Bradley Holbrook" <operations_bradley(at)servillian(dot)ca> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Drop Schema Error |
| Date: | 2011-01-28 23:53:59 |
| Message-ID: | 00fe01cbbf46$a1c21c20$e5465460$@servillian.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-01-29 16:57:55 | Re: Drop Schema Error |
| Previous Message | Dimitri Fontaine | 2011-01-28 16:45:53 | Re: Warm Standby looking for already applied log files |