Oops, should have searched the forum before posting. It looks like I just need to put migrate-False in my table definitions. However, that does prompt a follow up question.
If I use migrate=False in each of my tables and then modify my tables at a future date, will it update the tables or just ignore them? -jason On Feb 17, 4:03 pm, jlegler <[email protected]> wrote: > I've been developing a webapp against sqlite and in the process of > moving it to postgresql for production I have run into some problems. > This is the latest one: > > When using postgresql, web2py is complaining that tables defined in my > model already exist. > For example, when I call: > > auth.define_tables() > > I get an error saying: > > ProgrammingError: relation "auth_user" already exists. > > If I put an if statement on that function call, it simply moves down > the file to the next table definition and throws a similar error. Why > is this happening in postgresql and not sqlite? I am seriously > considering trying out mysql. Is anyone out there using postgresql > successfully? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
