Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 725836504CF for ; Sun, 6 Jul 2008 18:12:17 -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 89453-08 for ; Sun, 6 Jul 2008 18:12:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 709A96504C8 for ; Sun, 6 Jul 2008 18:12:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m66LCBo5016347; Sun, 6 Jul 2008 17:12:11 -0400 (EDT) To: "Kenaniah Cerny" cc: pgsql-ports@postgresql.org Subject: Re: contrib - fuzzystrmatch installation issue In-reply-to: References: Comments: In-reply-to "Kenaniah Cerny" message dated "Fri, 04 Jul 2008 18:31:49 -0700" Date: Sun, 06 Jul 2008 17:12:11 -0400 Message-ID: <16346.1215378731@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/7 X-Sequence-Number: 2659 "Kenaniah Cerny" writes: > I am running Postgres 8.3.3 on a CentOS box and I had a few issues when > trying to install the fuzzystrmatch library. The library seemed to compile > and make install correctly, but when I ran the sql scripts to add the > functions to a database, I came up with this issue: > # psql -d template1 -U postgres -f fuzzystrmatch.sql > SET > CREATE FUNCTION > CREATE FUNCTION > CREATE FUNCTION > CREATE FUNCTION > psql:fuzzystrmatch.sql:24: ERROR: could not find function "difference" in > file "/usr/lib/pgsql/fuzzystrmatch.so" > psql:fuzzystrmatch.sql:28: ERROR: could not find function "dmetaphone" in > file "/usr/lib/pgsql/fuzzystrmatch.so" > 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. Another thing that seems pretty odd is that the above complains about difference(), which *is* present in the .so according to nm. BTW, why are you compiling fuzzystrmatch for yourself at all, instead of just installing the postgresql-contrib RPM? regards, tom lane