OK, I'm upgrading. Ran into a snag with my passwords file and finding the
right port number, but when it's upgraded I'll see whether it does the
migration correctly.
Thanks
On Thursday, January 8, 2015 at 11:47:54 PM UTC-5, Massimo Di Pierro wrote:
>
> Please upgrade. This should have worked with that version but this is so
> old. Hard to day what the problem is.
>
> On Wednesday, 7 January 2015 13:42:52 UTC-6, Ian W. Scott wrote:
>>
>> 2.8.2-stable+timestamp.2013.11.28.13.54.07
>> (Running on Apache/2.2.17 (Unix) mod_wsgi/3.3 Python/2.7.8)
>>
>> On Wednesday, January 7, 2015 2:22:57 PM UTC-5, Massimo Di Pierro wrote:
>>>
>>> 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.
