Message-ID: <915896ff-9c88-410d-8764-90ba08329ef7@laposte.net>
Date: Fri, 10 May 2024 14:42:08 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: syntax error at or near "gist_trgm_ops" on debian
To: pgsql-admin@lists.postgresql.org
References: <1ad5dfef-1c9c-4407-bd61-222926877885@straussaudio.ch>
Content-Language: fr
From: =?UTF-8?Q?fran=C3=A7ois_Figarola?= <francois.figarola@laposte.net>
In-Reply-To: <1ad5dfef-1c9c-4407-bd61-222926877885@straussaudio.ch>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/915896ff-9c88-410d-8764-90ba08329ef7%40laposte.net>
Precedence: bulk

Le 10/05/2024 =C3=A0 14:00, Philippe Strauss a =C3=A9crit=C2=A0:
> Hello Postgres users,
>
> I'm Philippe from switzerland,
>
> I want to build a trigram index in a mycology database of mine,=20
> currently running on a debian laptop, and facing the following issue:
>
>
> diskpix=3D> CREATE INDEX idx_trgm_genus ON myco.genus USING GIST=20
> (myco.genus.name gist_trgm_ops);
> ERROR:=C2=A0 syntax error at or near "gist_trgm_ops"
> LINE 1: ...m_genus ON myco.genus USING GIST (myco.genus.name=20
> gist_trgm_...
>
>
> I've installed the postgresql-contrib package, rebooted my box, then=20
> created the trgm extension using:
>
>
> CREATE EXTENSION pg_trgm;
>
>
> But it still does not work, what am I missing?
>
Hello Philippe,

Perhaps you should try using ONLY the name of the column to index, not=20
specifying the table :

CREATE INDEX idx_trgm_genus ON myco.genus USING GIST (name gist_trgm_ops)=
;

Yours,
Fran=C3=A7ois