Michael Bayer wrote: >> True enough but it'd leave me poking into a "psycopg"-only >> structure when wanting to write non-psycopg-specific code >> (one goal one wants to achieve when using SQLAlchemy). > > once again, SA is only a wrapper to DBAPIs. if DBAPI had a standard > way to report SQLSTATE, then we'd tack that onto the SQLError, but as > far as I know, it doesnt.
Anyway, SQLSTATE only goes so far - if you want to know eg which unique constraint was violated, or which foreign key wasn't satisfied, you're back to per-database parsing the error message with a regexp. Which pretty much ties you to a specific database version and locale :( ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
