Re: Tracking Down Error in Stored Procedure

On 12/2/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Aaron Bono" <postgresql(at)aranya(dot)com> writes:
> > CONTEXT: PL/pgSQL function "update_web_site_hits_fn" line 200 at
> execute
> > statement
>
> > My question is this: What is line 200? Is it the 200th line after the
> > CREATE part of the stored procedure? Or is it the 200th line after the
> > BEGIN? Or maybe something else?
>
> It's the 200th line in the function body string. IIRC there is a
> special case to not count a leading newline in the body string,
> so that the counting goes like
>
> CREATE FUNCTION foo ...
> RETURNS ...
> AS $$
> DECLARE -- this is line 1
>
> or without exploiting the special case
>
> CREATE FUNCTION foo ...
> RETURNS ...
> AS $$DECLARE -- this is line 1
>
> regards, tom lane
>

I got it fixed. Thanks for the help!

--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================