Thread: Problem with catching my own exception messages.

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
......... ???


----------------------------------------------------------------------
Znajdz swoja milosc na wiosne... >>> http://link.interia.pl/f187a

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/

Does anyone know if there is a compiled version of libpq.dll (ssl
enabled)  that does not require
libintl-2.dll, libiconv-2.dll

Whoever compiled these dlls failed to include version information with
them, so it makes it a royal pain to deploy them, and it appears they
must be in the system dir.
I tried just sticking them in the same dir as my app with a renamed
libpq.dll and it did not work.
I would really like to rename libpq to something like libpq8.dll so my
app will grab that one instead of the one in system32.

The latest SP of windows 2000 and XP first look in the system dir and
then the app dir, which is reverse of how it worked before.

later,

Tony
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for PostgreSQL 8.x

>
>