Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9FD8B2E0060 for ; Wed, 26 Mar 2008 21:13:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73311-02 for ; Wed, 26 Mar 2008 21:13:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from QMTA05.emeryville.ca.mail.comcast.net (qmta05.emeryville.ca.mail.comcast.net [76.96.30.48]) by postgresql.org (Postfix) with ESMTP id 9A3102E0031 for ; Wed, 26 Mar 2008 21:13:31 -0300 (ADT) Received: from OMTA14.emeryville.ca.mail.comcast.net ([76.96.30.60]) by QMTA05.emeryville.ca.mail.comcast.net with comcast id 5q9Q1Z03c1HpZEsA50Tl00; Thu, 27 Mar 2008 00:11:50 +0000 Received: from [192.168.0.2] ([67.160.97.168]) by OMTA14.emeryville.ca.mail.comcast.net with comcast id 60DM1Z00C3dyZyT8a00000; Thu, 27 Mar 2008 00:13:26 +0000 X-Authority-Analysis: v=1.0 c=1 a=x0bW8ln2KaWnsT2DrYUA:9 a=N7wCawlolj9HM6osZeb7nD-uHFMA:4 a=si9q_4b84H0A:10 a=LY0hPdMaydYA:10 From: Adrian Klaver To: pgsql-sql@postgresql.org Subject: Re: Dropping Functions Date: Wed, 26 Mar 2008 17:13:26 -0700 User-Agent: KMail/1.9.1 Cc: Shawn References: <032620081632.25756.47EA7AA200070FAB0000649C22007374789D0A900E04050E@comcast.net> <200803262341.38648.postgres@xmtservices.net> <200803270005.48985.postgres@xmtservices.net> In-Reply-To: <200803270005.48985.postgres@xmtservices.net> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803261713.26745.aklaver@comcast.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/191 X-Sequence-Number: 30519 On Wednesday 26 March 2008 5:05 pm, Shawn wrote: > Hi Guys, > > Just a quick question. Is there a known problem with dropping function in > 8.2.6? I can make them but they can't be deleted. > > Shawn They will not deleted if something else depends on them i.e. a trigger. Can you show the error message if any? -- Adrian Klaver aklaver@comcast.net