Обсуждение: BUG #15461: Postgresql fuzzy match extension giving out error

Поиск
Список
Период
Сортировка

BUG #15461: Postgresql fuzzy match extension giving out error

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      15461
Logged by:          Gagandeep Singh Bhatia
Email address:      gagan.bhatia@xymob.in
PostgreSQL version: 9.6.6
Operating system:   x86_Linux 64 bits, compiled by gcc 4.8.2 20140120
Description:

I am using PostgreSQL DB hosted on AWS. I am trying to use fuzzy logic,
enabled its extension successfully. But running the fussy match Query gives
me an exception. Also verified, the extension is already enabled but still,
Query failed.

**Query used to enable extension** - CREATE EXTENSION pg_trgm;
**DB version details** - PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit
**Query for fuzzy match** - SELECT first_name FROM contact WHERE first_name
% 'Eve' LIMIT 10;

**Error message -** SQL Error [42883]: ERROR: operator does not exist:
character varying % unknown
  Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
  Position: 49
  org.postgresql.util.PSQLException: ERROR: operator does not exist:
character varying % unknown
  Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
  Position: 49

Re: BUG #15461: Postgresql fuzzy match extension giving out error

От
Tom Lane
Дата:
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> I am using PostgreSQL DB hosted on AWS. I am trying to use fuzzy logic,
> enabled its extension successfully. But running the fussy match Query gives
> me an exception. Also verified, the extension is already enabled but still,
> Query failed.

> **Query used to enable extension** - CREATE EXTENSION pg_trgm;
> **DB version details** - PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled
> by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit
> **Query for fuzzy match** - SELECT first_name FROM contact WHERE first_name
> % 'Eve' LIMIT 10;

> **Error message -** SQL Error [42883]: ERROR: operator does not exist:
> character varying % unknown

Hm, works for me.  Maybe you don't have the public schema in your
search_path?  By default, that's where pg_trgm's operators would be put.

            regards, tom lane