BUG #9038: trgm must have operand in index creation

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.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

=?UTF-8?Q?Tom=C3=A1=C5=A1_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, but you'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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs