On 12/2/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Aaron Bono" <[EMAIL PROTECTED]> 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 i
"Aaron Bono" <[EMAIL PROTECTED]> 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 so
I have a nightly batch that runs a stored procedure/function. This
procedure has a habit of erroring on the first of each month and gives the
following:
ERROR: cannot EXECUTE a null querystring
CONTEXT: PL/pgSQL function "update_web_site_hits_fn" line 200 at execute
statement
My question is t
