Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DF9891337B53 for ; Fri, 28 Jan 2011 19:54:18 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 20586-06 for ; Fri, 28 Jan 2011 23:54:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.shawcable.com (shawmail.shawcable.com [64.59.128.220]) by mail.postgresql.org (Postfix) with ESMTP id 06E301337B51 for ; Fri, 28 Jan 2011 19:54:10 -0400 (AST) Received: from bpd2mi1no-svcs.prod.shawcable.com ([10.0.184.120]) by bpd2mo3no-ssvc.prod.shawcable.com with ESMTP; 28 Jan 2011 16:54:09 -0700 X-Cloudmark-SP-Filtered: true X-Cloudmark-SP-Result: v=1.1 cv=rhzBfl3TH6jSClqh7E8qe//hARbvbzCI0ETuu7/2kJU= c=1 sm=1 a=BLceEmwcHowA:10 a=rFBdEGy9vS/m0A3AhxL8nA==:17 a=E1WOwkgUKAPRIKBvFQsA:9 a=iNM9O1rRSIgezr7ETi3xDQYwbacA:4 a=CjuIK1q_8ugA:10 a=yMhMjlubAAAA:8 a=SSmOFEACAAAA:8 a=3gpzFTVO-lcqjAMLM8oA:9 a=2cxrAIeQHRTVNI55opYA:7 a=YCdJ0i5E5K4L-kPJVoicY-pXN7cA:4 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117 X-IronPort-AV: E=Sophos;i="4.60,394,1291618800"; d="scan'208,217";a="498773389" Received: from unknown (HELO bpd2mi1no-cmts.prod.shawcable.com) ([192.168.183.120]) by bpd2mi1no-cmts.prod.shawcable.com with ESMTP; 28 Jan 2011 16:54:09 -0700 X-reinject: true Received: from unknown (HELO BradleyHolbrook) ([24.67.39.150]) by bpd2mi1no-dmz.prod.shawcable.com with ESMTP; 28 Jan 2011 16:54:09 -0700 From: "Bradley Holbrook" To: Subject: Drop Schema Error Date: Fri, 28 Jan 2011 15:53:59 -0800 Message-ID: <00fe01cbbf46$a1c21c20$e5465460$@servillian.ca> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00FF_01CBBF03.939F7860" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Acu/RizxNPHYfXg6Qvuotm2D+kticw== Content-Language: en-ca X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201101/188 X-Sequence-Number: 36628 This is a multipart message in MIME format. ------=_NextPart_000_00FF_01CBBF03.939F7860 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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? ------=_NextPart_000_00FF_01CBBF03.939F7860 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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?

------=_NextPart_000_00FF_01CBBF03.939F7860--