On 01/24/2014 02:07 PM, alexandros_e wrote:
With your help I found the solution. My DB was initially based on a 9.0
server and I had restored it on the 9.1 server. For some reason 9.0
fuzzystrmatch functions (levenstein...) were already present in this DB. So,
CREATE EXTENSION fuzzystrmatch did n
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 02:07 PM, alexandros_e wrote:
> With your help I found the solution. My DB was initially based on a
> 9.0 server and I had restored it on the 9.1 server. For some reason
> 9.0 fuzzystrmatch functions (levenstein...) were already present i
With your help I found the solution. My DB was initially based on a 9.0
server and I had restored it on the 9.1 server. For some reason 9.0
fuzzystrmatch functions (levenstein...) were already present in this DB. So,
CREATE EXTENSION fuzzystrmatch did not work. I had to manually remove
function 9.0
On 01/24/2014 01:38 PM, alexandros_e wrote:
=# \dx
List of installed extensions
Name | Version | Schema | Description
-+-++--
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
-# \df
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 01:38 PM, alexandros_e wrote:
> =# \dx List of installed extensions Name | Version | Schema |
> Description
> -+-++--
> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural l
=# \dx
List of installed extensions
Name | Version | Schema | Description
-+-++--
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
-# \df levenshtein*
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 01:28 PM, alexandros_e wrote:
> SELECT version();
>
> and
>
> \df levenshtein_less_equal
>
> "PostgreSQL 9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc
> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit"
>
> routing_nw2=# \df le
SELECT version();
and
\df levenshtein_less_equal
"PostgreSQL 9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 64-bit"
routing_nw2=# \df levenshtein_less_equal
List of functions
Schema | Name | Result data type | Argument
On 01/24/2014 01:19 PM, alexandros_e wrote:
Just this:
create extension fuzzystrmatch;
If the extension was not installed, then the simple levenstein distance
would not work either.
Which is what makes me think you are not connecting to the server you
think you are.
--
View this messag
Just this:
create extension fuzzystrmatch;
If the extension was not installed, then the simple levenstein distance
would not work either.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/levenshtein-less-equal-does-not-work-tp5788710p5788715.html
Sent from the Postgre
On 01/24/2014 01:07 PM, alexandros_e wrote:
Query:
SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
ERROR: function levenshtein_less_equal(unknown, unknown, integer) does not
exist
LINE 1: SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
^
HINT: No functi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 01:07 PM, alexandros_e wrote:
> SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
Did you CREATE the extension?
8<-
psql (9.3.2)
Type "help" for help.
iftest=# SELECT levenshtein_less_equal('exte
Query:
SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
ERROR: function levenshtein_less_equal(unknown, unknown, integer) does not
exist
LINE 1: SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
^
HINT: No function matches the given name and argument types. Y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 12:50 PM, alexandros_e wrote:
> For some reason levenshtein_less_equal does not work,
Define "does not work", i.e. cut and paste exact SQL and output so we
can see and reproduce your issue.
Joe
- --
Joe Conway
credativ LLC: http://www
Hello to all,
I always use PostgreSQL from enterpriseDB. I have both 9.2 and 9.1 latest
verions installed on two different Ubuntu 64bit machines. For some reason
levenshtein_less_equal does not work, in contrast to levenshtein which works
as expected. I even downloaded the src code for PostgreSQL
15 matches
Mail list logo