yeah, but you must be sure that those refer to the new database: if it's
the same app that worked with sqlite, those statements are for creating
tables in the sqlite database, not the new postgres one.
On Tuesday, December 18, 2012 10:04:22 AM UTC+1, at wrote:
>
>
> 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
>>>
>>>
>>>
>>>
--
