Search Postgresql Archives

Re: levenshtein_less_equal does not work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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-----


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux