this is more of a psycopg2 issue. anything that psycopg2 reports is
available in SA, such as exceptions which are wrapped in a
sqlalchemy.exceptions.SQLError and are accessible via the "orig"
parameter.
however, i have a suspicion that this information is not available in
current versions of psycopg, as its being discussed as a feature for
psycopg3:
http://www.mail-archive.com/gnumed-devel@gnu.org/msg03076.html
...i could not find any mention of SQLSTATE anywhere else in the
psycopg2 mailing lists or anywhere else related to psycopg at all.
you might want to try posting on the psycopg2 mailing list.
as far as *need*ing SQLSTATE, if you need it, then you need it. i
wouldnt think its usually a dealbreaker though, since a SQL error
message is typically an application failure which is passed straight
to an error log or screen, then read by humans....its a less common
design (and some would say, less practical design) for some SQL
errors to be filtered programmatically as normal business exceptions
and others as application errors (and even then, you could get away
with a regexp).
On Aug 15, 2006, at 6:57 PM, Karsten Hilbert wrote:
> Hi all,
>
> while evaluating whether to move to SA with our application
> (http://wiki.gnumed.de) I am wondering whether there is any
> way to access SQLSTATE information from within the SA
> framework. Some information on SQLSTATE (as applies to
> PostgreSQL) is here:
>
> http://www.postgresql.org/docs/8.1/interactive/errcodes-appendix.html
>
> Maybe there are good reasons why I don't *need* SQLSTATE
> when using SA ? If so, I'd like to hear them, too.
>
> (I am not yet on this list so please do keep me CCed for this thread.)
>
> Thanks,
> 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 easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
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 easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
