X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CEF63475EE2 for ; Tue, 13 May 2003 16:13:28 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id D549A475AA9 for ; Tue, 13 May 2003 16:13:24 -0400 (EDT) Received: from lerlaptop.iadfw.net (lerlaptop.iadfw.net [206.66.13.21]) (authenticated bits=0) by lerami.lerctr.org (8.12.9/8.12.9/20030225) with ESMTP id h4DKDLKK022644; Tue, 13 May 2003 15:13:21 -0500 (CDT) Date: Tue, 13 May 2003 15:13:21 -0500 From: Larry Rosenman To: Stephan Szabo Cc: josh@agliodbs.com, pgsql-sql@postgresql.org, tgl@sss.pgh.pa.us Subject: Re: Ok, how do I debug THIS? Message-ID: <295850000.1052856801@lerlaptop.iadfw.net> In-Reply-To: <20030513130508.Q30384-100000@megazone23.bigpanda.com> References: <20030513130508.Q30384-100000@megazone23.bigpanda.com> X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Spam-Status: No, hits=-26.0 required=5.0 tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/247 X-Sequence-Number: 13412 --On Tuesday, May 13, 2003 13:08:24 -0700 Stephan Szabo wrote: > On Tue, 13 May 2003, Larry Rosenman wrote: > >> >> >> --On Tuesday, May 13, 2003 14:58:01 -0500 Larry Rosenman >> wrote: >> >> >> >>> Ok, I'm blind or stupid, or quoting rules are biting my butt.... >> >> >> >>> record_values_new := record_values_new || '','' || >> >>> || quote_literal(NEW.netblock) || ''; >> >> >> >> Isn't the above an unterminated literal? Do you really need the last >> >> || '' part? >> > Eww. I'll bet your right. Damn Cut/paste and changing logic. :-). >> > >> > I'll go try that. >> Yep, that was it, now I get this, and I'm not sure how to deal with it... >> >> netmaster=# insert into networks values('111.111.111.0/24'); >> WARNING: Error occurred while executing PL/pgSQL function >> networks_trigger_log >> WARNING: line 19 at assignment >> ERROR: Function quote_literal(cidr) does not exist >> Unable to identify a function that satisfies the given argument >> types >> You may need to add explicit typecasts > > Ugh. cidr doesn't appear to cast to text. You may be able to go through > inet, but I'm not really sure because I haven't really used those types. looks like I can, **BUT** is this the RIGHT thing? I suspect it SHOULD cast to text. IMNSHO. Tom, Comments? LER > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749