pg_trgm Extension Installed but Operators and Functions do not exist

Поиск
Список
Период
Сортировка
От Igal @ Lucee.org
Тема pg_trgm Extension Installed but Operators and Functions do not exist
Дата
Msg-id fb4da7cb-6e21-cb61-0ddf-97ecc6d8f1a7@lucee.org
обсуждение исходный текст
Ответы Re: pg_trgm Extension Installed but Operators and Functions do not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения

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 instead the function word_similarity() I get a similar (no pun intended) error: function word_similarity(text, text) does not exist.

If I try to install the pg_trgm extension with `CREATE EXTENSION pg_trgm;` I get an error: extension "pg_trgm" already exists.

Running PostgreSQL 10.1, compiled by Visual C++ build 1800, 64-bit

Any ideas?  Thanks,

Igal Sapir
Lucee Core Developer
Lucee.org

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL Restore Database Without Backup and Log
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_trgm Extension Installed but Operators and Functions do not exist