I have been moving some data from sqlite to postgres. The first thing
I noticed was on csv export my boolean fields have True/False in the
field data. I didn't realize this until I tried to import these in to
postgres when the field is char(1) for boolean. I changed all the
True/False to T/F in the data and imported it. But now I'm getting
this error when trying to view a page:
File "applications/plugin_t2/modules/t2.py", line 402, in update
rows=table._db(query).select(table.ALL,limitby=(0,1))
File "gluon/sql.py", line 1245, in select
File "gluon/sql.py", line 1241, in response
File "gluon/sql.py", line 490, in <lambda>
ProgrammingError: argument of WHERE must be type boolean, not type integer
It looks like postgres has type boolean:
http://www.postgresql.org/docs/7.4/static/datatype-boolean.html
Should web2py be creating table fields of boolean for postgres on
checkbox fields? not char(1)?
I'm not sure where this error is being raised now that I look at this.
As the checkbox fields are char(1), but my dropdown fields are
integer in the actual pg database.
-wj
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
