BUG #9038: trgm must have operand in index creation

Поиск
Список
Период
Сортировка
От craig.macdonald@glasgow.ac.uk
Тема BUG #9038: trgm must have operand in index creation
Дата
Msg-id 20140130103559.8089.93549@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Paul Morie
Дата:
Сообщение: Re: BUG #9003: Hard-coding to localhost in postmaster
Следующее
От: levertond@googlemail.com
Дата:
Сообщение: BUG #9041: Strange error message with LATERAL and mixed WHERE/ON conditions