syntax error at or near "gist_trgm_ops" on debian

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Postgres users,

I'm Philippe from switzerland,

I want to build a trigram index in a mycology database of mine, currently running on a debian laptop, and facing the following issue:


diskpix=> CREATE INDEX idx_trgm_genus ON myco.genus USING GIST (myco.genus.name gist_trgm_ops);
ERROR:  syntax error at or near "gist_trgm_ops"
LINE 1: ...m_genus ON myco.genus USING GIST (myco.genus.name gist_trgm_...


I've installed the postgresql-contrib package, rebooted my box, then created the trgm extension using:


CREATE EXTENSION pg_trgm;


But it still does not work, what am I missing?

--
Philippe Strauss
https://straussengineering.ch/






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux