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
--
