yes it's the same application that worked properly with sqlite and now I am
trying to connect it to new postgres db.
sql.log doesn't have a single error message.
On Tue, Dec 18, 2012 at 2:38 PM, Niphlod <niph...@gmail.com> wrote:
> 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
>>>>
>>>>
>>>>
>>>> --
>
>
>
>
--
