Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DF5252E006E for ; Wed, 26 Mar 2008 21:25:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 67407-01 for ; Wed, 26 Mar 2008 21:25:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.xmtservices.net (unknown [66.224.65.210]) by postgresql.org (Postfix) with SMTP id 5DDF12E0064 for ; Wed, 26 Mar 2008 21:25:24 -0300 (ADT) Received: (qmail 12844 invoked from network); 27 Mar 2008 00:25:22 -0000 Received: from unknown (HELO vaio.xmtservices.net) (192.168.0.101) by errol.xmtservices.net with SMTP; 27 Mar 2008 00:25:22 -0000 From: Shawn To: pgsql-sql@postgresql.org Subject: Re: Dropping Functions Date: Thu, 27 Mar 2008 00:25:21 +0000 User-Agent: KMail/1.9.9 References: <032620081632.25756.47EA7AA200070FAB0000649C22007374789D0A900E04050E@comcast.net> <200803270005.48985.postgres@xmtservices.net> <200803261713.26745.aklaver@comcast.net> In-Reply-To: <200803261713.26745.aklaver@comcast.net> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803270025.21631.postgres@xmtservices.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/192 X-Sequence-Number: 30520 On Thursday 27 March 2008 00:13:26 Adrian Klaver wrote: > 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 Thanks Adrian, Sorry to bother you, I found it. I had 2 _ characters in the name and I was trying to delete with only 1. Talk about bonehead.... Shawn