Index postgresql_ops ignored when func.lower(column)

Here is code:

from sqlalchemy import Table, Column, Index, String, MetaData, func, create_engine

md = MetaData()
tbl = Table('t1', md, Column('col1', String()))
idx = Index('idx1', func.lower(tbl.c.col1), postgresql_ops={'col1': 'text_pattern_ops'})

e = create_engine("postgresql://postgres:postgres@localhost/test", echo=True)
with e.connect() as c:
    md.create_all(c)

Outputs

 Column |       Type        | Modifiers 
--------+-------------------+-----------
 col1   | character varying |

Indexes:
    "idx1" btree (lower(col1::text))  # NO text_pattern_ops!!!

Comments (5)