No title

Started by Florian Ledouxover 20 years ago1 messagesgeneral
Jump to latest
#1Florian Ledoux
florian.ledoux@gmail.com

Hello,

Having freshly installed a PG database (8.0.3), I have difficulties in
tracing exceptions in my PL/pgSQL functions. All my functions
implement a BEGIN-EXCEPTION-END block in which exceptions must be
traced :
BEGIN
-- Some stuff
EXCEPTION
WHEN OTHERS THEN
-- trace
END;

I would like to trace the SQLCODE that triggers the exception. I have
heard about a SQLSTATE variable but it doesn't seem to be implemented
in the 8.0.3 but only in the 8.1 (not stable release and so not a good
choice in a professional context...).

How can I get this information ? Is there a patch available ? Is there
a workaround ?

Thanks