pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Logging in Stored Procedure 2+ messages / 2 participants [nested] [flat]
* Logging in Stored Procedure @ 2006-07-12 23:28 Aaron Bono <postgresql@aranya.com> 0 siblings, 1 reply; 2+ messages in thread From: Aaron Bono @ 2006-07-12 23:28 UTC (permalink / raw) To: pgsql-sql 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 ================================================================== ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Logging in Stored Procedure @ 2006-07-13 00:10 Gregory S. Williamson <gsw@globexplorer.com> parent: Aaron Bono <postgresql@aranya.com> 0 siblings, 0 replies; 2+ messages in thread From: Gregory S. Williamson @ 2006-07-13 00:10 UTC (permalink / raw) To: Aaron Bono <postgresql@aranya.com>; pgsql-sql 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 your version 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! ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-07-13 00:10 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-07-12 23:28 Logging in Stored Procedure Aaron Bono <postgresql@aranya.com> 2006-07-13 00:10 ` Gregory S. Williamson <gsw@globexplorer.com>
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