Hi Johann,
Yes, I started the db in postgres is totally empty.
As y suggested I've removed all the files in databases/ but I am still
getting the same error.
What do you mean with "drop all the app-related-tables" ?
currently I am saving the db with db.export_to_csv_file()
Regards,
paolo
Il 13.06.2012 12:08 Johann Spies ha scritto:
On 13 June 2012 10:55, Paolo <ilva...@inventati.org [1]> wrote:
Hi all,
I am getting several errors switching from sqlite to postgres
Are you starting out on PostgreSQL with an empty database?
my connection string for sqlite was:
db = DAL('sqlite://storage.sqlite', migrate=True)
while for postgres is:
db = DAL('postgres://web2py:web2py@localhost:5432/mydb',
migrate=True)
so far, I got tickets saying
ProgrammingError: relation "auth_user" already exists
Which means that DAL could not create the table 'auth_user' because
there was one already.
If you start with an empty database, drop all the app-related-tables
in Postgresql and remove all the files in
/web2py/applications/your_app/database
Otherwise if all the tables already in the PostgreSQL-database, try
starting your database connection with 'migrate = False' or specify
the migrate option per table.
Regards
Johann
--
Paolo
