Re: Problem with catching my own exception messages.

On Tue, Jun 07, 2005 at 05:49:10PM +0200, Gorodowienko Daniel wrote:
>
> I want to write a function that returns a raise message catched by:
> EXCEPTION
>  WHEN RAISE_EXCEPTION THEN
>    RETURN .........
> If exception was raise like this:
> RAISE EXCEPTION 'some exception';
> and I want to get 'some exception', so what should I write instead of
> ......... ???

As far as I know you can't do this in any released version of
PostgreSQL, but in 8.1 you'll be able to get the error message
from the SQLERRM variable.

http://archives.postgresql.org/pgsql-committers/2005-06/msg00135.php

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