Postgresapp: gin_trgm_ops does not exist for access method "gin"

[beckmx]

Hello, I have been working on a project that is shared by several members, and lately I cannot use my postgress installation for this problem:

PG::UndefinedObject: ERROR: operator class "gin_trgm_ops" does not exist for access method "gin"

Any ideas?

[tbussmann]

seems you don't have the pg_trgm extension installed in the database in question. Try CREATE EXTENSION pg_trgm;

[sailing]

Even with the extension installed, I still see this, on 9.4.9.1

[sailing]

@beckmx, to clarify what @tbussmann responded, you need to \c to the database in question before running CREATE EXTENSION pg_trgm;

By default PostgresApp has you on your personal DB.

[quocgfy]

Works great for me. thanks!

[jakob]

Glad it worked! Since there's nothing to do for us here, I'm closing this issue.

[leandropadua]

Thanks for the solution. That worked partially for me. The full solution was to apply it to every schema by adding the schema pg_catalog to the end of it:
create extension pg_trgm with schema pg_catalog;

[jhoval]

It worked for me as well, with another extension related to GIN (intarray). I needed to select the schema as @leandropadua mentioned.

create extension intarray with schema nameOfMySchema