Re: [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:  closed
      Priority:  medium            |  Milestone:
     Component:  sql               |   Severity:  no triage selected yet
    Resolution:  duplicate         |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+------------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => duplicate
 * status_field:  awaiting triage => completed/closed


Comment:

 you can't use bound parameters in DDL, #2742 looks to improve this so this
 is a duplicate.

 {{{
 #!python
     __table_args__ = (
         Index(
             'organization_name_search_ix',
             func.to_tsvector(text("'english'"), func.lower(name)),
             postgresql_using='gin'
         ),
     )
 }}}

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