see databases/sql.log to see what went wrong.
On Tuesday, December 18, 2012 7:53:39 AM UTC+1, at wrote:
>
>
> Hi,
>
> Previously I was working on sqlite database with web2py. Now I've
> installed postgresql-9.1.7-1-windows-x64, created a user role (testuser)
> and database (testdb) and tested connectivity using psql; all went fine.
>
> Then I've define following statement in db.py:
> *db = DAL('postgres://testuser:12345@localhost/testdb')*
>
> Previously it was:
> #db = DAL('sqlite://storage.sqlite')
>
> Web2py and application started successfully, but it doesn't create tables
> defined in db.py; consider the following def:
> *db.define_table('taxpayer',
> Field('name'),
> Field('married', 'boolean'),
> Field('spouse_name'))
> *
> When I try to insert records in this table, I get following error message:
> <class 'gluon.contrib.pg8000.errors.ProgrammingError'> ('ERROR', '42P01',
> 'relation "taxpayer" does not exist')
>
> Can somebody help please ?
>
> Thanks & Regards
> AT
>
>
>
>
--
