pg.ddx.io  pgsql-ports@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joe Conway <mail@joeconway.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kenaniah Cerny <kenaniah@gmail.com>
Cc: pgsql-ports@postgresql.org
Subject: Re: contrib - fuzzystrmatch installation issue
Date: Sun, 06 Jul 2008 14:16:06 -0700
Message-ID: <48713616.9000204@joeconway.com> (raw)
In-Reply-To: <16346.1215378731@sss.pgh.pa.us>
References: <f647f4600807041831t700fd800qbfd49cc302b1a40f@mail.gmail.com>
	<16346.1215378731@sss.pgh.pa.us>

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




view thread (3+ messages)

Message-ID: <48713616.9000204@joeconway.com>
Permalink:  ../48713616.9000204@joeconway.com/
Also on:    postgresql.org/message-id/48713616.9000204@joeconway.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-ports@postgresql.org
  Cc: mail@joeconway.com, tgl@sss.pgh.pa.us, kenaniah@gmail.com
  Subject: Re: contrib - fuzzystrmatch installation issue
  In-Reply-To: <48713616.9000204@joeconway.com>
  References: <f647f4600807041831t700fd800qbfd49cc302b1a40f@mail.gmail.com> <16346.1215378731@sss.pgh.pa.us> <48713616.9000204@joeconway.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox