[sqlalchemy] how can i detect fields that cause an exception ?

hi, I'm using sqlalchemy 0.7.3 and postgresql 9 with psycopg2 and python 2.7. When I put wrong type of data(ex: 'some string' into Integer field), I get DataError exception in commit phase. This is so expected result, but i think it would be great to get more specific data which can tell

Re: [sqlalchemy] how can i detect fields that cause an exception ?

DataError is a psycopg2 exception. psycopg2 in turn is doing what PG's client API provides for them. So if you wanted those messages to name the column that's the target of an INSERT or UPDATE you'd have to look into improving psycopg2 and/or how Postgresql's client system works. Normally,

Re: [sqlalchemy] how can i detect fields that cause an exception ?

I've got an idea from your answer. Thank you. -Original Message- From: Michael Bayer mike...@zzzcomputing.com Sender: sqlalchemy@googlegroups.com Date: Tue, 1 Nov 2011 11:15:03 To: sqlalchemy@googlegroups.com Reply-To: sqlalchemy@googlegroups.com Subject: Re: [sqlalchemy] how can i