Thread: BUG #9038: trgm must have operand in index creation
The following bug has been logged on the website: Bug reference: 9038 Logged by: Craig Macdonald Email address: craig.macdonald@glasgow.ac.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
No it's not. The documentation about full-text clearly states that the column needs to be either tsvector or tsquery, butyou're clearly using text. Tomas craig.macdonald@glasgow.ac.uknapsal/a: >The following bug has been logged on the website: > >Bug reference: 9038 >Logged by: Craig Macdonald >Email address: craig.macdonald@glasgow.ac.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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-bugs
Tomáš Vondra <tv@fuzzy.cz> writes: > craig.macdonald@glasgow.ac.uknapsal/a: >> 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: > No it's not. The documentation about full-text clearly states that the column needs to be either tsvector or tsquery, butyou're clearly using text. Yeah, Tomas is right: section 12.9 is discussing the core full-text-search datatypes, which have nothing much to do with contrib/pg_trgm's facilities. regards, tom lane