How to track exceptions in PL/pgSQL - Mailing list pgsql-general

From Florian Ledoux
Subject How to track exceptions in PL/pgSQL
Date
Msg-id d4f1fdd90510120340l48a71d6dj@mail.gmail.com
Whole thread Raw
Responses Re: How to track exceptions in PL/pgSQL  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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 exception occurs (the trace will be rollbacked
too) ?

Thanx

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: License question[VASCL:A1077160A86]
Next
From: Ivan Pavlov
Date:
Subject: Re: error in SELECT from store procedure