> On Mar 21, 3:31 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > > > Yeah psycopg2 with python 3 / sqlalchemy is not supported yet. The python > > 3 supported version of psycopg2 came out like, in the past two weeks. It > > will be 0.7 where its supported at all, hopefully soon as its a matter of > > setting up some flags in the dialects. In the meantime if you want to > > start working with pg + SQLA + py3k you can try the python 3 version of > > pg8000 - its not as nice or anywhere near as fast as psycopg2 but it works > > in at least a rudimentary fashion. > > > Also Python 3.2 is the latest version of py3k and actually has some fairly > > dramatic behavioral differences vs. 3.1. If you want to work with 3.2 and > > let us know what quirks you find...
Below is one (Python 3.2, sqlalchemy 0.7b4 (downloaded snapshot 10min ago), Debian). Best wishes, Hans-Martin Traceback (most recent call last): File "src/library/db_connect.py", line 60, in existing_schemata tmp = session.execute("""SELECT schema_name from information_schema.schemata;""") File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/orm/session.py", line 758, in execute return self._connection_for_bind(bind, close_with_result=True).execute( File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/orm/session.py", line 694, in _connection_for_bind return self.transaction._connection_for_bind(engine) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/orm/session.py", line 246, in _connection_for_bind conn = bind.contextual_connect() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 2062, in contextual_connect self.pool.connect(), File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/pool.py", line 208, in connect return _ConnectionFairy(self).checkout() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/pool.py", line 369, in __init__ rec = self._connection_record = pool._do_get() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/pool.py", line 695, in _do_get con = self._create_connection() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/pool.py", line 173, in _create_connection return _ConnectionRecord(self) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/pool.py", line 257, in __init__ pool.dispatch.first_connect.exec_once(self.connection, self) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/event.py", line 227, in exec_once self(*args, **kw) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/event.py", line 236, in __call__ fn(*args, **kw) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/strategies.py", line 162, in first_connect dialect.initialize(c) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/dialects/postgresql/base.py", line 793, in initialize super(PGDialect, self).initialize(connection) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/default.py", line 171, in initialize self._get_server_version_info(connection) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/dialects/postgresql/base.py", line 964, in _get_server_version_info v = connection.execute("select version()").scalar() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 1259, in execute params) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 1436, in _execute_text statement, parameters File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 1519, in _execute_context result = context.get_result_proxy() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/dialects/postgresql/psycopg2.py", line 198, in get_result_proxy return base.ResultProxy(self) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 2420, in __init__ self._init_metadata() File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 2427, in _init_metadata self._metadata = ResultMetaData(self, metadata) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/engine/base.py", line 2283, in __init__ colname = dialect._description_decoder(colname) File "lib/python3.2/site-packages/SQLAlchemy-0.7b4dev-py3.2.egg/ sqlalchemy/processors.py", line 69, in process return decoder(value, errors)[0] File "lib/python3.2/encodings/utf_8.py", line 16, in decode return codecs.utf_8_decode(input, errors, True) TypeError: 'str' does not support the buffer interface -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.