databases/sql.log contains only success messages .. no errors there
On Tuesday, 18 December 2012 13:36:25 UTC+5, Niphlod wrote:
>
> 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
>>
>>
>>
>>
--
