Re: contrib - fuzzystrmatch installation issue

Tom Lane wrote:
>> psql:fuzzystrmatch.sql:32: ERROR: could not find function "dmetaphone_alt"
>> in file "/usr/lib/pgsql/fuzzystrmatch.so"
>
> I'm suspicious that /usr/lib/pgsql/fuzzystrmatch.so is actually the 7.4
> version of that module (which is what shipped in RHEL4 to begin with,
> and which would've lacked exactly those three functions). However a
> hole in this theory is that an 8.3 server should've refused to load
> a 7.4 extension module at all. Anyway, double check versions,
> installation locations, etc. A self-configured Postgres installation
> would not default to installing into /usr/lib/pgsql, so it certainly
> seems possible that that file isn't your newly built version.

He had also written me directly off list -- version mismatch it was. See
below. I should have thought to copy the list on my reply -- sorry about
that.

Joe

----------------------
Kenaniah Cerny wrote:
> Joe,
>
> You hit the nail right on the head. Apparently, I was trying to use
> Postgres 7.4.x with the 8.1.11 contrib version. Upgrading Postgres to
> 8.1 solved the issue. Can't believe I did that.
>
> Thanks for pointing it out. It would be a great addition to the
> documentation if the contrib functions were labeled with the versions
> that they first appear in the stable distro. It would most definitely
> help out people like me :-/
>
> And sorry for the double-email.
>
> Thanks,
> Kenaniah
>
> On Sat, Jul 5, 2008 at 4:10 PM, Joe Conway <mail(at)joeconway(dot)com
> <mailto:mail(at)joeconway(dot)com>> wrote:
>
> Kenaniah Cerny wrote:
>
> The compiler didn't return any errors during the build process,
> leaving me clueless as to why it's not working correctly.
>
> If you have any insight, please feel free to shoot me back an
> email or to call me at (951) 385-9506, as it is slightly urgent.
>
>
> I see that you simultaneously wrote to the list, but please do that
> first next time.
>
> You haven't provided enough information to be sure, but it sounds to
> me like you have at least two different versions of Postgres
> installed -- probably both 8.3.3 and 7.4.x. Try doing:
>
> locate fuzzystrmatch.so
>
> In 7.4.x the functions being complained about did not exist. You
> could also try doing:
>
>
> psql -d template1 -U postgres
> template1=# select version();
>
> and see what version of postgres you wind up attached to.
>
> Joe
>
>