From: | Tomáš Vondra <tv(at)fuzzy(dot)cz> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #9038: trgm must have operand in index creation |
Date: | 2014-01-30 15:34:39 |
Message-ID: | jo41r5ylj62pn67vic0mt5yk.1391096079117@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
No it's not. The documentation about full-text clearly states that the column needs to be either tsvector or tsquery, but you're clearly using text.
Tomas
craig(dot)macdonald(at)glasgow(dot)ac(dot)uknapsal/a:
>The following bug has been logged on the website:
>
>Bug reference: 9038
>Logged by: Craig Macdonald
>Email address: craig(dot)macdonald(at)glasgow(dot)ac(dot)uk
>PostgreSQL version: 9.2.0
>Operating system: Documentation
>Description:
>
>The documentation at
>http://www.postgresql.org/docs/9.2/static/textsearch-indexes.html
>is incorrect in the syntax of CREATE INDEX for GIN and GIST. According to
>http://www.postgresql.org/docs/9.2/static/pgtrgm.html the keyword
>gist_trgm_ops is also necessary:
>
>test=> CREATE INDEX trgm_idx ON test_trgm USING gist (t);
>ERROR: data type text has no default operator class for access method
>"gist"
>test=> CREATE INDEX trgm_idx ON test_trgm USING gist (t gist_trgm_ops);
>CREATE INDEX
>
>
>
>--
>Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-bugs
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-01-30 18:01:25 | Re: BUG #9038: trgm must have operand in index creation |
Previous Message | levertond | 2014-01-30 15:10:03 | BUG #9041: Strange error message with LATERAL and mixed WHERE/ON conditions |