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