From: Aaron Bono <postgresql@aranya.com>
To: sql pgsql <pgsql-sql@postgresql.org>
Subject: Tracking Down Error in Stored Procedure
Date: Fri, 1 Dec 2006 23:48:12 -0600
Message-ID: <bf05e51c0612012148u1b1e8003i5706215097dca5ea@mail.gmail.com> (raw)
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 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? I have a possible culprit at both places
and don't know which one is the offender.
Also, if the EXECUTE is over many lines, is line 200 the first line of the
EXECUTE statement or the ending line of the EXECUTE (where the ; is)?
I am using PostgreSQL 8.1.3 on CENTOS Linux.
Thanks,
Aaron
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com
Subject: Re: Tracking Down Error in Stored Procedure
In-Reply-To: <bf05e51c0612012148u1b1e8003i5706215097dca5ea@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox