[web2py] Postgres migration errors

2018-07-29 Thread Joe Barnhart
Iā€™d get rid of the idiom: db.colname==ā€œ%sā€%pythonvar Just replace it with: db.colname==pythonvar ā€” Joe -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) ---

[web2py] Postgres migration errors

2018-07-26 Thread Rahul
Hi Everyone, I recently migrated my entire SQLite database to Postgre 9.x . While almost all my changes are working fine, I am getting errors for a few SQL statements like below for sections in my dashboard. (i) this statement and below statement is throwing the error - However if