On Nov 13, 12:23 pm, Carlos <carlosgali...@gmail.com> wrote: > Hi, > > Maybe the problem is that, for the same app, I started with sqlite and > then switched to progresql?. > > Anyways, I just dropped the database in progresql and deleted all > files in /databases/, and it seems to be working ok now (so far). > > Can you please confirm the above (switching from sqlite to progresql) > caused my problems?.
No. This should not be a problem unless you deleted the sqlite database and the .table AFTER the postgresql db was created. > > I want to know, in order to confirm I will not have these problems in > a production environment. > > Thanks again, > > Carlos > > On Nov 13, 12:02 pm, Carlos <carlosgali...@gmail.com> wrote: > > > Hi Massimo, > > > I did not delete any *.table files located at: > > > .\web2py\applications\(app)\databases\ > > > Should I try deleting them?. > > > How can this get corrupted?. > > > What else should I try?. > > > Thanks, > > > Carlos > > > On Nov 13, 10:54 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > Corrupted database/*.table > > > > did you delete them? > > > > On Nov 12, 3:45 pm, Carlos <carlosgali...@gmail.com> wrote: > > > > > Hi, > > > > > I'm getting the following error in my local installation with > > > > postgresql when using auth.define_tables(migrate=True): > > > > > <class 'psycopg2.ProgrammingError'>(relation "auth_user" already > > > > exists) > > > > > web2py™ Version 1.89.1 (2010-11-12 15:14:36) > > > > Python Python 2.6.4: C:\Python26\python.exe > > > > > Traceback (most recent call last): > > > > File "C:\web2py\gluon\restricted.py", line 188, in restricted > > > > exec ccode in environment > > > > File "C:/web2py/applications/test/models/model.py", line 38, in > > > > <module> > > > > auth.define_tables(migrate=True) > > > > File "C:\web2py\gluon\tools.py", line 1163, in define_tables > > > > format='%(first_name)s %(last_name)s (%(id)s)') > > > > File "C:\web2py\gluon\sql.py", line 1371, in define_table > > > > t._create(migrate=migrate, fake_migrate=fake_migrate) > > > > File "C:\web2py\gluon\sql.py", line 1823, in _create > > > > self._db._execute(query) > > > > File "C:\web2py\gluon\sql.py", line 1026, in <lambda> > > > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > > > > ProgrammingError: relation "auth_user" already exists > > > > > Any ideas what could be wrong?. > > > > > Thanks, > > > > > Carlos > >
