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@joeconway.com
 > <mailto:mail@joeconway.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
 >
 >