| From: | craig(dot)macdonald(at)glasgow(dot)ac(dot)uk |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #9038: trgm must have operand in index creation |
| Date: | 2014-01-30 10:35:59 |
| Message-ID: | 20140130103559.8089.93549@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | levertond | 2014-01-30 15:10:03 | BUG #9041: Strange error message with LATERAL and mixed WHERE/ON conditions |
| Previous Message | Bruce Momjian | 2014-01-30 01:35:01 | Re: BUG #9003: Hard-coding to localhost in postmaster |