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.