0
When trying to create an index of type GIN in a table I came across the following error:
CREATE INDEX idx_descricao on produtos USING gin (descricao gin_trgm_ops);
ERRO: classe de operadores "gin_trgm_ops" não existe para método de acesso "gin"
So everything indicates the syntax is correct and the column used for this type of index is text
PS: Postgres 9.6
You have the pg_trgm module installed?
– anonimo
True, I hesitate. I missed activating the EXTENSION pg_trgm.
– Fabricio