can you show us the code? On Tuesday, 15 January 2013 02:25:50 UTC-6, pbreit wrote: > > 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 > >
--
