Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #105

Re: SQL state /

From "M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups comp.databases.postgresql
Subject Re: SQL state /
Date 2011-04-30 18:00 +0200
Message-ID <922q12Fcr5U2@mid.uni-berlin.de> (permalink)
References <be953af4-d251-4de9-b405-f5bc7b44c11c@hg8g2000vbb.googlegroups.com>

Show all headers | View raw


Am 26.04.2011 15:28, schrieb Dog is love:
> Hi,
> 
> I was trying to trap the SQL States as listed in
> 
>   http://www.postgresql.org/docs/8.2/static/errcodes-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.

I can tell you I can't trap any errors in pltcl, the error is
reflected to the client.

/Str.

Back to comp.databases.postgresql | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

SQL state / Dog is love <michaelnewportyahoo.com@gmail.com> - 2011-04-26 06:28 -0700
  Re: SQL state / Jasen Betts <jasen@xnet.co.nz> - 2011-04-30 10:54 +0000
  Re: SQL state / "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-30 18:00 +0200
    Re: SQL state / "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-05-04 10:21 +0200

csiph-web