See http://web2py.com/books/default/chapter/29/06#Migrations:
The value of migrate is the filename (in the "databases" folder for the application) where web2py stores internal migration information for this table. These files are very important and should never be removed except when the entire database is dropped. In this case, the ".table" files have to be removed manually. Anthony On Sunday, January 6, 2013 12:31:41 PM UTC-5, GeeksRule wrote: > > Resolved this by removing *.table files under the *application/database/* > Restarted postgres > Restart apache > > Is this a bug ? > > On Sunday, 6 January 2013 11:43:53 UTC-5, GeeksRule wrote: >> >> >> I switched to Postgres recently and things were working fine. >> I had to make some major changes, hence deleted the old database & >> created a brand new one. >> >> I accessed a function that inserts new records in a table -> "newsMaster" >> But in the logs I see this : >> >> [error] Trying to insert title : xxxxxxxxxxxxx >> >> [error] oops: relation "newsmaster" does not exist >> >> [error] LINE 1: INSERT INTO NewsMaster(name,favorite... >> >> [error] ^ >> >> [error] >> >> [error] Trying to insert title : 'xxxxxxxxxxxxxxxx >> >> [error] oops: current transaction is aborted, commands ignored until end >> of transaction block >> >> I didn't have to do anything different when I switched to Postgres, it >> just created the tables from scratch.. >> Am I missing something ? >> > --
