This field definition seams to be a problem for postgres but not for
sqlite. Can somebody tell me why?
Field('connection_name', required=True, compute=lambda row:
db.plugin_lookout_connections[row['connection_id']].alias)
This is the error I get using postgres:
Traceback (most recent call last):
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/restricted.py", line
205, in restricted
exec ccode in environment
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/applications/theseus/controllers/plugin_lookout.py",
line 663, in <module>
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/globals.py",
line 173, in <lambda>
self._caller = lambda f: f()
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/tools.py",
line 2575, in f
return action(*a, **b)
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/applications/theseus/controllers/plugin_lookout.py",
line 202, in plugin_lookout_tables
constraints = dict(plugin_lookout_tables=table_set) #
get_data_with_permissions('plugin_lookout_tables')
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 1989, in smartgrid
user_signature=user_signature,**kwargs)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 1568, in grid
formname=formname)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/html.py",
line 1994, in process
self.validate(**kwargs)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/html.py",
line 1941, in validate
if self.accepts(**kwargs):
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 1274, in accepts
self.vars.id = self.table.insert(**fields)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/dal.py",
line 6829, in insert
return self._db._adapter.insert(self,self._listify(fields))
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/dal.py",
line 928, in insert
raise e
InternalError: current transaction is aborted, commands ignored until
end of transaction block
