Re: SQLSTATE

Karsten Hilbert <[email protected]> Mon, 26 Jun 2006 18:17:55 +0200
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
On Mon, Jun 26, 2006 at 05:17:15PM +0200, Gerhard H=E4ring wrote:

> > do you see any chance pyPgSQL could provide SQLSTATE in the
> > very near future ?
> =

> Seems doable. As attribute of the exception object or did you have =

> anything else in mind?
Well, for all practical purposes it being an attribute of
the exception would be the proper place to put it IMO. It
might be an idea to perhaps also put it into the string of
the exception itself such as

 "[SQLSTATE:xxxx] OperationalError: ..."

This is similar to how Oracle (and psycopg, currently) does it.

That way, someone coding against DB-API *only* might still
have a chance to get at the value.

Karsten
-- =

GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easi=
er
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D1=
21642