[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists

2013-04-25 Thread Niphlod
yes ideally you run in production with migrate=False. When you need to change table models, than migrate=True. When you run into sync problems, and only then, fake_migrate_all is there to help. On Thursday, April 25, 2013 6:47:35 PM UTC+2, at wrote: > > > Thanks for the help. It worked. > >

[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists

2013-04-25 Thread at
Thanks for the help. It worked. After regeneration of .table files, fake_migrate_all flag should be set to False again, right? Regards On Thursday, 25 April 2013 17:04:15 UTC+5, Niphlod wrote: > > you may have the mytable file but the connection string when it was > generated was different (t

[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists

2013-04-25 Thread Niphlod
you may have the mytable file but the connection string when it was generated was different (there's a hash in front of all .table files just for this). Anyway, if you're sure that you don't need to trigger any migration, just set fake_migrate_all=True for one request and all .table files will