but i guess you know this, since i just quoted your own message ! On Aug 16, 2006, at 9:09 PM, Michael Bayer wrote:
> 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 ------------------------------------------------------------------------- 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
