Re: levenshtein_less_equal does not work

-----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 in
> this DB. So, CREATE EXTENSION fuzzystrmatch did not work. I had to
> manually remove function 9.0 fuzzystrmatch functions and then
> CREATE EXTENSION .... worked perfectly and levenstein_less_equal as
> well. So, it was error from the DB restored from an older version
> of postgresql.

Normally in this situation you are supposed to do something like this
after the dump/restore:

CREATE EXTENSION fuzzystrmatch FROM unpackaged;

The file fuzzystrmatch--unpackaged--1.0.sql which is shipped with
fuzzystrmatch will then "do the right thing" (at least in theory,
can't say I have tried it extensively). But your method works too ;-)

Joe

- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJS4uV8AAoJEDfy90M199hlaRYP/2ODsaC4SuVmpv1+XiyMjfoV
MB5Mvwerlngw/WgGZMf/E7bDnOzGlReXRG9t8pCaT+DuwXgnvK7JlaOU8yCZaf1N
wUBFf9N4XU21swNpgZU7UIOEfVM1r8dWQaQtP3bVOapTDiWQTnJIymAHouz3Mgn7
3dUwcurVSv2p3WCVsTXaQMwy2wK4BmUftkT2ooPpG00HodZc6zsiu/PO660RAw8W
hyxYPv8tqHPBq1GTM2wcXNU9AYO7gzrvSGwxNZP2JKthSIUBdl7bUXGSe422MC9O
9bfNVFMzOtOBdNIdkmsAre2yROFs1rSa9nvwqdJJ9bmkQOLfX6+2LPsfSZWda5HE
3ifpfjfwFnEGfKKJZqnb4r1giHWFXQ2rcKAtUIBumUj5l3y/3Yw1S1cOx0lzTeF4
BvauvvQPn9+ynEh8/eSFUNDlTxpSp+QQWfc06KO+nU3f2UUMKXRNiswiDxlwwuyj
YBYdnpwg3jc9ePLqDMDYScACDzxVoEWL0AEYyFZkkTV/wCP37bK/y+HoKC2onyIm
Uk/LCMsisDcv0aFgkDDZ7zqJ8KlWcP0+ZTvAKMH3TVIP+rPJ4X/XhQKV8L8Dzhc5
fsZ383QIFtODxxRHFyLNVj1dYmq3+Jg5P6YmVFdw1e0HGP5KA2pCgKPcrEOoF5BF
x4g2W68HwWgxtw21NlLC
=mkQE
-----END PGP SIGNATURE-----