On 18 November 2010 14:03, mdipierro <mdipie...@cs.depaul.edu> wrote:
> This is a reasonable error now.
>
> when you change a field type (but not the name) web2py tries to
> convert the data. In this case postgres fails because it does not know
> how to convert dates to integers.
>
> You have to do it in multiple steps:
>
> - remove the field from define_table
> - run appadmin once (field will be dropped)
> - add the field again with same name and different type
> - run appadmin once (new field will be created)
>
> web2py will not try to attepmt to post the data in the column and it
> will be lost, but no error.
>
>
Thanks.
Regards
Johann
--
May grace and peace be yours in abundance through the full knowledge of God
and of Jesus our Lord! His divine power has given us everything we need for
life and godliness through the full knowledge of the one who called us by
his own glory and excellence.
2 Pet. 1:2b,3a
