Problem migrating field type from 'string' to 'text' (postgresql)

[Ian W. Scott]

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?

[Massimo Di Pierro]

which web2py version/date?

[Ian W. Scott]

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)

[Massimo Di Pierro]

Please upgrade. This should have worked with that version but this is so old. Hard to day what the problem is.

[Ian W. Scott]

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

[Paolo Valleri]

Hi,

I've checked and web2py trunk works as expected (both directions namely string to text and viceversa)

@scott, have you enabled migration? ( DAL(db_uri, migrate=True))

Paolo

[Ian W. Scott]

Thanks Paolo. That was it. I forgot that I had set migrate to False. I really feel foolish, but thanks for pointing me in the right direction.

Ian