[Sqlalchemy-tickets] [sqlalchemy] #2800: Unable to create tsvector functional index
Brought to you by:
zzzeek
|
From: sqlalchemy <mi...@zz...> - 2013-08-14 20:11:05
|
#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
|