Re: [sqlalchemy] sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range

2015-07-14 Thread Chengjun JIN
Hi Michael, Thanks for your time. I have figured out the problem. My error is not related to the data type, as you pointed out. It is related to the definition of the TABLE column repeatedly and inconsistently (meaning: initially I define the column as Integer in the database, then I changed

[sqlalchemy] sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range

2015-07-13 Thread Chengjun JIN
Hi all, I am trying to save data into postgresql via sqlchemy ORM. I encountered an error below: sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range I pinpoint the place where it goes wrong. I have a large number which is 2468432255.0. If I change to smaller number like

Re: [sqlalchemy] sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range

2015-07-13 Thread Mike Bayer
On 7/13/15 7:02 PM, Chengjun JIN wrote: Hi all, I am trying to save data into postgresql via sqlchemy ORM. I encountered an error below: sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range I pinpoint the place where it goes wrong. I have a large number which is