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