How to track exceptions in PL/pgSQL

From: Florian Ledoux <florian(dot)ledoux(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to track exceptions in PL/pgSQL
Date: 2005-10-12 10:40:29
Message-ID: d4f1fdd90510120340l48a71d6dj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Pavlov 2005-10-12 11:35:52 Re: error in SELECT from store procedure
Previous Message Oliver Elphick 2005-10-12 10:06:50 Re: License question[VASCL:A1077160A86]