[Sqlalchemy-tickets] [sqlalchemy] #2800: Unable to create tsvector functional index

[sqlalchemy <mi...@zz...>]

#2800: Unable to create tsvector functional index
----------------------+-----------------------------------------
 Reporter:  meunierd  |           Owner:  zzzeek
     Type:  defect    |          Status:  new
 Priority:  medium    |       Milestone:
Component:  sql       |        Severity:  no triage selected yet
 Keywords:            |  Progress State:  awaiting triage
----------------------+-----------------------------------------
 {{{
 class Organization(Base):
     __tablename__ = 'organization'

     id = Column(Integer, primary_key=True)
     name = Column(Unicode, unique=True)
     business_number = Column(Unicode(255), unique=True)
     website = Column(Unicode)

     is_donor = Column(Boolean, nullable=False, default=False)
     is_member = Column(Boolean, nullable=False, default=False)

     __table_args__ = (
         Index(
             'organization_name_search_ix',
             func.to_tsvector('english', func.lower(name)),
             postgresql_using='gin'
         ),
     )
 }}}

 Produces the following mangled SQL output:

 {{{
 2013-08-14 15:56:58,170 INFO  [sqlalchemy.engine.base.Engine][MainThread]
 {}
 2013-08-14 15:56:58,191 INFO  [sqlalchemy.engine.base.Engine][MainThread]
 COMMIT
 2013-08-14 15:56:58,194 INFO  [sqlalchemy.engine.base.Engine][MainThread]
 CREATE INDEX organization_name_search_ix ON organization USING gin
 (to_tsvector(%(to_tsvector_1)s, lower(name)))
 2013-08-14 15:56:58,194 INFO  [sqlalchemy.engine.base.Engine][MainThread]
 {}
 2013-08-14 15:56:58,194 INFO  [sqlalchemy.engine.base.Engine][MainThread]
 ROLLBACK
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2800>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python