Hi,

I was trying to trap the SQL States as listed in

http://www.postgresql.org/docs/8.2/s...-appendix.html

in a normal pg/plsql script but I can't seem to do it....is it only
possible to do this in Embedded SQL ?

I do not want to test the error code, I only want to pass it back to a
JAVA front end.

On 2011-04-26, Dog is love <michaelnewportyahoo.com (AT) gmail (DOT) com> wrote:
I think you need to use the keyword in plpgsql.

in plpgsql I think you need to use the constants like this:

EXCEPTION WHEN io_error OR undefined_file THEN

postgres should pass the error code to the client automatically
if the error is not trapped. I don't know how JAVA represents SQL
errors. In python I get an exception object containing. among other
things the SQL error code.

eg: if I do "select 1/0;" I get an exception raised and "22012"
(which means dizision by zero) as the error code


--
⚂⚃ 100% natural

Am 26.04.2011 15:28, schrieb Dog is love:
I can tell you I can't trap any errors in pltcl, the error is
reflected to the client.

/Str.

Am 30.04.2011 18:00, schrieb M. Strobel:
Corrected:

in pltcl I can catch errors, and I get the error messsage as text.

I still can not find the sql state anywhere.

/Str.