Error creating GIN type index

Asked

Viewed 33 times

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

  • 1

    You have the pg_trgm module installed?

  • True, I hesitate. I missed activating the EXTENSION pg_trgm.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.