PGIndexLoader chokes on functional indicies

Given an index of the form:

CREATE INDEX my_index ON my_table USING btree (my_function(my_table.*));

Generating python model for table my_table
Traceback (most recent call last):
  File "sqlautocode-0.5.1/autocode.py", line 4, in ?
    sqlautocode.main()
  File "/var/djfleetinv/devel/sqlautocode-0.5.1/sqlautocode/__init__.py",
line 73, in main
    indexes = db.dialect.indexloader(db).indexes(table)
  File "/var/djfleetinv/devel/sqlautocode-0.5.1/sqlautocode/loader.py",
line 22, in indexes
    return [self._index_from_def(name, sqltext, table)
  File "/var/djfleetinv/devel/sqlautocode-0.5.1/sqlautocode/loader.py",
line 33, in _index_from_def
    cols = [table.columns[cname.strip().replace('"', '')]
  File
"/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.6dev_r4452-py2.4.egg/sqlalchemy
/util.py",
line 476, in __getitem__
    return self._data[key]
KeyError: 'my_function(my_table.*'

Original issue reported on code.google.com by agross...@gmail.com on 30 May 2008 at 4:30

unalloc / sqlautocode

PGIndexLoader chokes on functional indicies #4