Problems when excluding a column with an index

When I try to autoload a table, while ignoring some of its columns (for this I specify include_columns=..), if one of the excluded columns is indexed, sqlalchemy crashes:

Traceback (most recent call last): File "/home/someuser/prj_theproject/theproject2/eggs/zope.testing-3.7.1-py2.5.egg/zope/testing/testrunner/runner.py", line 360, in run_layer setup_layer(options, layer, setup_layers) File "/home/someuser/prj_theproject/theproject2/eggs/zope.testing-3.7.1-py2.5.egg/zope/testing/testrunner/runner.py", line 536, in setup_layer layer.setUp() File "/home/domas/prj_theproject/theproject2/src/theproject/tests/init.py", line 54, in setUp relative_to=conf_dir) File "/home/someuser/prj_theproject/theproject2/eggs/PasteDeploy-1.3.3-py2.5.egg/paste/deploy/loadwsgi.py", line 204, in loadapp return loadobj(APP, uri, name=name, kw) File "/home/someuser/prj_theproject/theproject2/eggs/PasteDeploy-1.3.3-py2.5.egg/paste/deploy/loadwsgi.py", line 225, in loadobj return context.create() File "/home/someuser/prj_theproject/theproject2/eggs/PasteDeploy-1.3.3-py2.5.egg/paste/deploy/loadwsgi.py", line 625, in create return self.object_type.invoke(self) File "/home/someuser/prj_theproject/theproject2/eggs/PasteDeploy-1.3.3-py2.5.egg/paste/deploy/loadwsgi.py", line 110, in invoke return fix_call(context.object, context.global_conf, context.local_conf) File "/home/someuser/prj_theproject/theproject2/eggs/PasteDeploy-1.3.3-py2.5.egg/paste/deploy/util/fixtypeerror.py", line 57, in fix_call val = callable(args, kw) File "/home/domas/prj_theproject/theproject2/src/theproject/config/middleware.py", line 63, in make_app setup_orm(meta.engine) File "/home/domas/prj_theproject/theproject2/src/theproject/model/init.py", line 184, in setup_orm include_columns='group_id', 'subject_id', 'subject_location_id', 'page_id') File "/home/someuser/prj_theproject/theproject2/eggs/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/schema.py", line 113, in call return type.call(self, name, metadata, args, *kwargs) File "/home/someuser/prj_theproject/theproject2/eggs/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/schema.py", line 239, in init autoload_with.reflecttable(self, include_columns=include_columns) File "/home/someuser/prj_theproject/theproject2/eggs/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 1265, in reflecttable self.dialect.reflecttable(conn, table, include_columns) File "/home/someuser/prj_theproject/theproject2/eggs/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/databases/postgres.py", line 658, in reflecttable schema.Index(name, [table.columnsc for c in columns], File "/home/someuser/prj_theproject/theproject2/eggs/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/util.py", line 634, in getitem return self._datakey KeyError: u'terms'

Comments (2)