From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | josh(at)agliodbs(dot)com, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Ok, how do I debug THIS? |
Date: | 2003-05-13 19:58:01 |
Message-ID: | 283090000.1052855881@lerlaptop.iadfw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
--On Tuesday, May 13, 2003 12:56:36 -0700 Stephan Szabo
<sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:
>
> 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?
Eww. I'll bet your right. Damn Cut/paste and changing logic. :-).
I'll go try that.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2003-05-13 20:00:43 | Re: Ok, how do I debug THIS? |
Previous Message | Stephan Szabo | 2003-05-13 19:56:36 | Re: Ok, how do I debug THIS? |