Hi to alls,

I have a problem with import and export real/float datatype from postgres 
to spatialite and viceversa.

I have a table with some colums defined like this:         
Column('skeleton_lenght', Float(2,2))

The sqlalchemy method charges the table in a Postgres DB and in a 
Spatialite DB (I use on my PC spatialite, and when I can stay in office 
Postgres)

On spatialite the column type Float remains Float, but in Postgres the 
Column becomes Real.

On Mapper Class I use '%f' to mapping the columns and variables, and all 
it's ok when I save or I update data.

BUT, when I try to import from spatialite to postgres and viceversa, 
SQLALCHEMY tell me, there is an invalid sintax for real.

If I set all with Numeric, the problem doesn't appear.

What Can I do with Float type?

Best regards

Luca

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to