Re: [GENERAL] How to track exceptions in PL/pgSQL

2005-10-12 Thread Michael Fuhr
On Wed, Oct 12, 2005 at 12:40:29PM +0200, Florian Ledoux wrote: > I would like to track (timestamp and error number) in the database or > in text files the exceptions that occur in my PL/pgSQL functions. > > 1. How can I retrieve the SQLCODE in a 8.0.3 PG server ? You can't, at least not that I'm

[GENERAL] How to track exceptions in PL/pgSQL

2005-10-12 Thread Florian Ledoux
Hello, I would like to track (timestamp and error number) in the database or in text files the exceptions that occur in my PL/pgSQL functions. 1. How can I retrieve the SQLCODE in a 8.0.3 PG server ? 2. How can I trace the exception in a table although an implicit rollback is done when a exceptio