[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists
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 be regenerated without trying to do anything to your database tables. On Thursday, April 25, 2013 12:24:59 PM UTC+2, at wrote: > > Hi, > > I am trying to connect to a remote postgres database running on a ubuntu > server. The application is hosted on windows 7 server. Getting following > error on application startup: > ('ERROR', '42P07', > 'relation "mytable" already exists') > The strange thing is in databases folder, I already have mytable file. Any > idea what could be the issue? > > Thanks, > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists
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 (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 be regenerated without trying to do anything to your database > tables. > > On Thursday, April 25, 2013 12:24:59 PM UTC+2, at wrote: >> >> Hi, >> >> I am trying to connect to a remote postgres database running on a ubuntu >> server. The application is hosted on windows 7 server. Getting following >> error on application startup: >> ('ERROR', '42P07', >> 'relation "mytable" already exists') >> The strange thing is in databases folder, I already have mytable file. >> Any idea what could be the issue? >> >> Thanks, >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists
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. > > 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 (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 be regenerated without trying to do anything to your database >> tables. >> >> On Thursday, April 25, 2013 12:24:59 PM UTC+2, at wrote: >>> >>> Hi, >>> >>> I am trying to connect to a remote postgres database running on a ubuntu >>> server. The application is hosted on windows 7 server. Getting following >>> error on application startup: >>> ('ERROR', >>> '42P07', 'relation "mytable" already exists') >>> The strange thing is in databases folder, I already have mytable file. >>> Any idea what could be the issue? >>> >>> Thanks, >>> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.