creating records in web2py after migration to postgresql

[Aydin]

I have moved my database from SQlite to postgresql. The problem I have is that when I try to create any table, it does not return any notice and refreshes the page and does not create the record. I have some tables and none of them create a record. I am creating the records using admin page on the website just like I did with SQLite. I read it is the same way with postgresql.

[Aydin]

I can create records in the interface of the postgresql and they show up in the web2py database admin. But the user I created in postgresql cannot login to the app. There is no error. 

Using SQLite, I could create records by web2py's database admin. is it still possible to create records if you use postgresql or not? Because as I said in the frist post, they do not get created. 

[jonatha...@whatho.net]

Do you have a question, because I an struggling to understand what it is?

[Aydin]

Yes, the question is I have no log or error to debug for the issue:

After migration to postregsql and removing the errors, the insert record does not work. It returns no error. The record does not get created.

[jonatha...@whatho.net]

OK, can you interact with the postgresql database using the DAL standalone as described in http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Using-the-DAL-stand-alone-? Can you insert records via this mechanism? Do you get any error?

Usually when testing in this way I run python [path]/web2py.py -M -S appname which loads the models for the app I am concerned with.