Hello,
I am having problems using sqlalchemy to write values to Postgresq
columns of type Float. I am getting "sqlalchemy.exc.ProgrammingError:
(ProgrammingError) can't adapt" errors when I try to insert records.
My Postgresql table is defined as:
Column | Type
| Modifiers
----------------+--------------------------------
+------------------------------------------------------------------
max_pm25 | double precision |
mean_pm25 | double precision |
After importing the Postgresql dialect:
from sqlalchemy.dialects.postgresql import *
I define my sqlalchemy table as:
class dream4_eta_15km_pm10(Base):
__tablename__='pm10_dream_rasters'
max_pm10=Column(DOUBLE_PRECISION)
mean_pm10=Column(DOUBLE_PRECISION)
Any help appreciated,
Bill
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
