Hello,
I'm trying to use greenplum database with web2py. It is modified
postgresql to support big data storage, it uses many postgresql's
tools. I created test apllication, and tables are created, but if I
try to register, I get following error:
Traceback (most recent call last):
File "/home/users/brushek/web2py/gluon/restricted.py", line 192, in
restricted
exec ccode in environment
File "/home/users/brushek/web2py/applications/testgp/controllers/
default.py", line 71, in <module>
File "/home/users/brushek/web2py/gluon/globals.py", line 145, in
<lambda>
self._caller = lambda f: f()
File "/home/users/brushek/web2py/applications/testgp/controllers/
default.py", line 33, in user
return dict(form=auth())
File "/home/users/brushek/web2py/gluon/tools.py", line 1080, in
__call__
return getattr(self,args[0])()
File "/home/users/brushek/web2py/gluon/tools.py", line 1778, in
register
onvalidation=onvalidation,hideerror=self.settings.hideerror):
File "/home/users/brushek/web2py/gluon/sqlhtml.py", line 1223, in
accepts
self.vars.id = self.table.insert(**fields)
File "/home/users/brushek/web2py/gluon/dal.py", line 4786, in insert
return self._db._adapter.insert(self,self._listify(fields))
File "/home/users/brushek/web2py/gluon/dal.py", line 848, in insert
id = self.lastrowid(table)
File "/home/users/brushek/web2py/gluon/dal.py", line 1768, in
lastrowid
self.execute("select currval('%s')" % table._sequence_name)
File "/home/users/brushek/web2py/gluon/dal.py", line 1262, in
execute
return self.log_execute(*a, **b)
File "/home/users/brushek/web2py/gluon/dal.py", line 1257, in
log_execute
ret = self.cursor.execute(*a,**b)
NotSupportedError: currval() not supported
Does anybody tryied to use greenplum with web2py ?
Regards
brushek
