I need to migrate an existing database field from (the implicit default)
'string' to 'text'. Since all of the existing data will satisfy the new
field contstraints (no 'string' will be ruled out as 'text') I just changed
the field type in the model field definition.
Old:
Field('response1'),
New:
Field('response1', 'text'),
Everything seemed to go fine until I tried creating a new record with a
long string in that field. I got the following error:
<class 'psycopg2.DataError'>(value too long for type character varying(512)
).
It looks to me like my postgresql database hasn't actually changed the data
type for that column. I thought this would be taken care of by the DAL
migration. So how can I change the actual postgre column data type? Or did
I do something wrong in the migration?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
