Thread: Logging in Stored Procedure

OK, maybe a stupid simple question but, how do you add logging to a stored procedure?  My procedure is running but the
resultsI get are not complete and I need to see better what is going wrong.  The tool I use has a debugger but the
debuggeris barfing at a particular line that, when run without the debugger, works with no errors so I know there is
somethingwrong with the debugger. <br /><br />Thanks,<br />Aaron<br clear="all" /><br />-- <br
/>==================================================================<br/>   Aaron Bono<br />   Aranya Software
Technologies,Inc.<br />   <a href="http://www.aranya.com">http://www.aranya.com </a><br
/>================================================================== 

Well, perhaps the NOTICE functionality, e.g.

RAISE NOTICE ''report id of % for date %'', rpt_rec.report_id, rpt_rec.report_s_date;

This will show on the terminal if running from a console, and also writes to the log, IIRC. See the documentation for
yourversion for details. 

HTH,

Greg Williamson
DBA
GlobeXplorer LLC


-----Original Message-----
From:    pgsql-sql-owner@postgresql.org on behalf of Aaron Bono
Sent:    Wed 7/12/2006 4:28 PM
To:    Postgres SQL language list
Cc:
Subject:    [SQL] Logging in Stored Procedure

OK, maybe a stupid simple question but, how do you add logging to a stored
procedure?  My procedure is running but the results I get are not complete
and I need to see better what is going wrong.  The tool I use has a debugger
but the debugger is barfing at a particular line that, when run without the
debugger, works with no errors so I know there is something wrong with the
debugger.

Thanks,
Aaron

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


!DSPAM:44b58e5178651804284693!