From: | "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org> |
---|---|
To: | |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_trgm Extension Installed but Operators and Functions do not exist |
Date: | 2018-01-28 20:49:31 |
Message-ID: | 6fe73c13-cb22-09ca-bcd8-a11947be71a1@lucee.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1/28/2018 12:35 PM, Tom Lane wrote:
> "Igal @ Lucee.org" <igal(at)lucee(dot)org> writes:
>> I am trying to run a query which was working a few weeks ago, and it
>> utilizes the <<-> operator but I am getting an error: operator does not
>> exist text <<-> text.
>>
>> If I try to install the pg_trgm extension with `CREATE EXTENSION
>> pg_trgm;` I get an error: extension "pg_trgm" already exists.
> Seems like a likely bet is that the extension is installed in a schema
> that isn't in your search_path.
Thank you, Tom. I was unaware of the fact that extensions are installed
to specific schemas.
For future users who might face this issue, I fixed it by re-creating
the extension in the pg_catalog schema, which is always in the
search_path [1]:
DROP EXTENSION pg_trgm;
CREATE EXTENSION pg_trgm SCHEMA pg_catalog;
Thanks again,
Igal
[1]
https://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-SEARCH-PATH
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-01-28 21:45:31 | Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP |
Previous Message | Tom Lane | 2018-01-28 20:35:32 | Re: pg_trgm Extension Installed but Operators and Functions do not exist |