Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 48A546504CF for ; Sun, 6 Jul 2008 18:16:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 93197-04 for ; Sun, 6 Jul 2008 18:16:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from joeconway.com (wsip-72-214-29-243.sd.sd.cox.net [72.214.29.243]) by postgresql.org (Postfix) with ESMTP id 398776504C8 for ; Sun, 6 Jul 2008 18:16:07 -0300 (ADT) Received: from [192.168.4.40] (account jconway [192.168.4.40] verified) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 6674756; Sun, 06 Jul 2008 14:16:06 -0700 Message-ID: <48713616.9000204@joeconway.com> Date: Sun, 06 Jul 2008 14:16:06 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.5.0.12-3.fc6 pango-text Thunderbird/1.5.0.12 Mnenhy/0.7.5.666 MIME-Version: 1.0 To: Tom Lane CC: Kenaniah Cerny , pgsql-ports@postgresql.org Subject: Re: contrib - fuzzystrmatch installation issue References: <16346.1215378731@sss.pgh.pa.us> In-Reply-To: <16346.1215378731@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/8 X-Sequence-Number: 2660 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 > 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 > >