Is it still preferable to use psycopg2 instead of pg8000 after this fix? El lunes, 15 de junio de 2015, 5:28:09 (UTC-5), Paolo Valleri escribió: > > According to my tests, the current PG adapter works only with psycopg2 and > python2.7 > It is broken with both pg8000 and psycopg2 on python 3.x > > A possible fix for pg8000 and python2.7 is here > https://github.com/ilvalle/pydal/commit/d5450938ae606a3e85deffa831899a35146f5e64 > > I've posted an issue for psycopg2 with python3.x here > https://github.com/psycopg/psycopg2/issues/331#issuecomment-111909256 > > Paolo > > On Saturday, June 13, 2015 at 5:22:07 AM UTC+2, Massimo Di Pierro wrote: >> >> It is a bug in pg8000. You need to install psycopg2 >> >> On Friday, 12 June 2015 13:51:55 UTC-5, Antonio Salazar wrote: >>> >>> I have the same problem. PostgreSQL database, web2py >>> 2.11.2-stable+timestamp.2015.05.30.16.33.24 >>> source install. >>> >>> Now any field update which has non-ASCII characters fails with "<type >>> 'exceptions.UnicodeDecodeError'> 'ascii' codec can't decode byte 0xc3 in >>> position X: ordinal not in range(128)" >>> By any field update, I mean custom forms, form grids, and even database >>> administration. >>> >>> This is the traceback after failing to change a user's name to "José" >>> with database administration: >>> >>> Traceback (most recent call last): >>> File "S:\Extranet\Website\Fuentes\web2py\gluon\restricted.py", line 227, >>> in restricted >>> exec ccode in environment >>> File >>> "S:/Extranet/Website/Fuentes/web2py/applications/extranet/controllers/appadmin.py" >>> <http://127.0.0.1:8000/admin/edit/extranet/controllers/appadmin.py>, line >>> 704, in <module> >>> File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, in >>> <lambda> >>> self._caller = lambda f: f() >>> File >>> "S:/Extranet/Website/Fuentes/web2py/applications/extranet/controllers/appadmin.py" >>> <http://127.0.0.1:8000/admin/edit/extranet/controllers/appadmin.py>, line >>> 343, in update >>> if form.accepts(request.vars, session): >>> File "S:\Extranet\Website\Fuentes\web2py\gluon\sqlhtml.py", line 1686, in >>> accepts >>> self.id_field_name]).update(**fields) >>> File >>> "S:\Extranet\Website\Fuentes\web2py\gluon\packages\dal\pydal\objects.py", >>> line 2020, in update >>> ret = db._adapter.update("%s" % table._tablename,self.query,fields) >>> File >>> "S:\Extranet\Website\Fuentes\web2py\gluon\packages\dal\pydal\adapters\base.py", >>> line 996, in update >>> raise e >>> UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 57: >>> ordinal not in range(128) >>> >>> >>> I don't recall having this problem with pre 2.10 versions >>> >>
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
