I'm trying to connect to a DB that has some user-defined types. Is this
supported in Web2py? I get:
Traceback (most recent call last):
File "/Users/pbreit/Sites/web2py/gluon/restricted.py", line 212, in restricted
exec ccode in environment
File
"/Users/pbreit/Sites/web2py/applications/balanced/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/balanced/controllers/default.py>,
line 95, in <module>
File "/Users/pbreit/Sites/web2py/gluon/globals.py", line 193, in <lambda>
self._caller = lambda f: f()
File
"/Users/pbreit/Sites/web2py/applications/balanced/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/balanced/controllers/default.py>,
line 39, in holds
(db.holds.marketplace_guid.like('MP%'))).select()
File "/Users/pbreit/Sites/web2py/gluon/dal.py", line 8966, in select
return adapter.select(self.query,fields,attributes)
File "/Users/pbreit/Sites/web2py/gluon/dal.py", line 1636, in select
return self._select_aux(sql,fields,attributes)
File "/Users/pbreit/Sites/web2py/gluon/dal.py", line 1601, in _select_aux
self.execute(sql)
File "/Users/pbreit/Sites/web2py/gluon/dal.py", line 1714, in execute
return self.log_execute(*a, **b)
File "/Users/pbreit/Sites/web2py/gluon/dal.py", line 1708, in log_execute
ret = self.cursor.execute(*a, **b)
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/dbapi.py", line 246, in
_fn
return fn(self, *args, **kwargs)
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/dbapi.py", line 317, in
execute
self._execute(operation, args)
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/dbapi.py", line 322, in
_execute
self.cursor.execute(new_query, *new_args)
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/interface.py", line
399, in execute
self._stmt.execute(*args, **kwargs)
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/interface.py", line
169, in execute
self._row_desc, cmd = self.c.bind(self._portal_name, self._statement_name,
args, self._parse_row_desc, kwargs.get("stream"))
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/protocol.py", line 943,
in _fn
return fn(self, *args, **kwargs)
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/protocol.py", line
1117, in bind
output_fc = [types.py_type_info(f) for f in row_desc.fields]
File "/Users/pbreit/Sites/web2py/gluon/contrib/pg8000/types.py", line 162, in
py_type_info
raise NotSupportedError("type oid %r not mapped to py type" % type_oid)
NotSupportedError: type oid 20716 not mapped to py type
--
