And settings.migrate is set to 'True'.
On Sep 8, 1:45 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote: > 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.