From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | gagan(dot)bhatia(at)xymob(dot)in |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15461: Postgresql fuzzy match extension giving out error |
Date: | 2018-10-26 10:13:00 |
Message-ID: | 25712.1540548780@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2018-10-26 10:55:57 | BUG #15462: WITH ORDINALITY and CTEs don't work |
Previous Message | PG Bug reporting form | 2018-10-26 10:03:59 | BUG #15461: Postgresql fuzzy match extension giving out error |