which web2py version/date?
On Wednesday, 7 January 2015 12:49:29 UTC-6, Ian W. Scott wrote:
>
> 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.
