Re: Ok, how do I debug THIS?

--On Tuesday, May 13, 2003 12:31:34 -0700 Josh Berkus <josh(at)agliodbs(dot)com>
wrote:

> Larry,
>
>> but the function is:
>>
>> $ wc -l z
>> 147 z
>> $ head z
>> CREATE OR REPLACE FUNCTION networks_trigger_log () RETURNS "trigger"
>> AS 'DECLARE
>> record_fields_old text;
>> record_values_old text;
>> record_fields_new text;
>> record_values_new text;
>> query_string_old text;
>> query_string_new text;
>> BEGIN
>> query_string_old := ''INSERT INTO networks_log'';
>
> 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.

How do I debug it?

(I can post the whole thing, but it's butt ugly (still in development)).

>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>

--
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