[sqlalchemy] postgres and server_side_cursors

[Michele Petrazzo]

Hi,
I'm trying the "new" server_side_cursors option with pg  and I see that
I receive an error when I use the server_side_cursors=True and the Table
autoload=True. The autoload=True with the server_side_cursors=False
work. The server_side_cursors=True specifying the table structure work.

(I'm using the last svn version)


book_pg = Table('book', md_pg, autoload=True)


    book_pg = Table('book', md_pg, autoload=True)

    metadata.get_engine().reflecttable(table)

    self.dialect.reflecttable(conn, table)

    for name, format_type, default, notnull, attnum, table_oid in rows:

    yield self.__parent._get_col(self.__row, i)

    rec = self._convert_key(key)

    rec = self.props[key]
KeyError: 0

md_pg = BoundMetaData('postgres://[EMAIL PROTECTED]:5432/book', server_side_cursors=False) File "/usr/lib/python2.4/site-packages/sqlalchemy/schema.py", line 143, in __call__ File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 508, in reflecttable File "/usr/lib/python2.4/site-packages/sqlalchemy/databases/postgres.py", line 357, in reflecttable File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 732, in __iter__ File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 634, in _get_col File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 622, in _convert_key

smime.p7s
Description: S/MIME Cryptographic Signature