[web2py] SQlite to Postgres insert problems

2015-11-18 Thread Carla Raquel
I'm having some troubles importing from csv files while using a Postgres connection, when a table has one or more references to other tables like so: db.define_table('Extension', Field('Person',db.auth_user), Field('Supervisor',db.auth_user),

Re: [web2py] SQlite to Postgres insert problems

2015-11-18 Thread António Ramos
Be carefull that imported records will get a fresh new id and because of that you may get that error. ;) Em 18/11/2015 15:35, "Carla Raquel" escreveu: > I'm having some troubles importing from csv files while using a Postgres > connection, when a table has one or more

[web2py] sqlite to postgres

2012-03-27 Thread Marco Tulio Cicero de M. Porto
Hi! I was using sqlite as my database for a few projects, but decided to go to postgres. While to web2py going from one to another is pretty much a connection string that you'll change, there's still one problem remaining. How do I get the data that was on my app (on the sqlite database). On a