Drop Schema Error - Mailing list pgsql-admin

From Bradley Holbrook
Subject Drop Schema Error
Date
Msg-id 00fe01cbbf46$a1c21c20$e5465460$@servillian.ca
Whole thread Raw
Responses Re: Drop Schema Error
List 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?

pgsql-admin by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Warm Standby looking for already applied log files
Next
From: Tom Lane
Date:
Subject: Re: Drop Schema Error