X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 16FCE475EE2 for ; Tue, 13 May 2003 15:56:36 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 8B8E2475AA9 for ; Tue, 13 May 2003 15:56:35 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 78DCBD67F; Tue, 13 May 2003 12:56:36 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 6E8AA5C03; Tue, 13 May 2003 12:56:36 -0700 (PDT) Date: Tue, 13 May 2003 12:56:36 -0700 (PDT) From: Stephan Szabo To: Larry Rosenman Cc: , Subject: Re: Ok, how do I debug THIS? In-Reply-To: <273950000.1052855357@lerlaptop.iadfw.net> Message-ID: <20030513125451.J30140-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-26.6 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, QUOTE_TWICE_1,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/243 X-Sequence-Number: 13408 On Tue, 13 May 2003, Larry Rosenman wrote: > > Larry, > > > >> > You seem to be missing most of your function, here. > >> I just did a head. Note the line count above. It's only 147 > >> lines, but the error refers to line 206. > > > > Obviously postgres is counting lines differently from you. > > > > Post the whole thing, or start from the bottom of the function and work > > your way up until you find the problem. Most likely issue: missing > > semicolon. > > 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?