Drop the table... and recreate it... Use pgAdmin or erase your db model reload your app... paste your model reload...
Don't need fake migrate just migrate true... Richard On Thu, Sep 8, 2011 at 1:36 PM, Eric <hu5...@gmail.com> wrote: > I'm running web2py on PostGreSQL. I accidentally created a model that > specified a table with column type "double" when I needed "decimal". > Now I'm trying to change it from double to decimal, with no luck. I > deleted all the records, and have used > 'migrate=True,fake_migrate=True', and all the variations thereof. > Will I need to re-create the app to change the database field type? > > Changing models (adding or modifying columns) is a problem I've > encountered consistently with web2py, and it's the one problem that > (so far) I've been unable to trace back to my own mistake or > oversight. Working with the DAL is not easy, even when using > PostGreSQL. > > Thanks in advance for your help.
