Here is the error when using PostGreSQL:
Traceback (most recent call last):
File "gluon/restricted.py", line 178, in restricted
exec ccode in environment
File "/path/to/applications/test/models/db.py", line 17, in ?
db=SQLDB('postgres://user:p...@localhost:5432/database')
File "gluon/sql.py", line 967, in __init__
self._execute("SET standard_conforming_strings=on;")
File "gluon/sql.py", line 962, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: parameter "standard_conforming_strings" cannot be
changed
Looks like web2py isn't compatible with postgres 8.1?