Re: calling EXECUTE on any exception

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: gherzig(at)fmed(dot)uba(dot)ar
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: calling EXECUTE on any exception
Date: 2005-07-29 14:45:33
Message-ID: 20050729144533.GA84062@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Jul 29, 2005 at 10:36:52AM -0300, gherzig(at)fmed(dot)uba(dot)ar wrote:
> EXCEPTION
> WHEN OTHER THEN
> EXECUTE exception_handler(Exception_code)
>
> how do i get that error_code (or code_name, whatever i can get)
> generated in the something() function to be proccesed by the
> exception_handler() function?

I don't think you can do this in released versions of PostgreSQL.
In 8.1 you'll be able to use SQLSTATE to get the error code and
SQLERRM to get the error message.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-07-29 15:42:48 Re: Why are these queries so different in time?
Previous Message gherzig 2005-07-29 13:36:52 calling EXECUTE on any exception