I think you will have to show a bit your model... You can also just copy/paste your app and rename it and change the db connexion setting create a new db and load your app... If you still have trace back... You most probably have mistake in your model...
Richard On Thu, Sep 8, 2011 at 6:21 PM, Eric <hu5...@gmail.com> wrote: > 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. >