8.3 to 8.4 - Can't load dynamic shared library - Mailing list pgsql-admin

From Craig James
Subject 8.3 to 8.4 - Can't load dynamic shared library
Date
Msg-id 4C3F583C.50208@emolecules.com
Whole thread Raw
Responses Re: 8.3 to 8.4 - Can't load dynamic shared library  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: 8.3 to 8.4 - Can't load dynamic shared library  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 8.3 to 8.4 - Can't load dynamic shared library  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu 10.04.

On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load on 8.4:

CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_session_id'
LANGUAGE 'C' VOLATILE;
ERROR:  could not load library "/usr/local/pgsql/lib/libchmoogle.so": /usr/local/pgsql/lib/libchmoogle.so: undefined
symbol:_ZN9OpenBabel4etabE 

So it finds the first shared library, libchmoogle.so.  But the symbol _ZN9OpenBabel4etabE is from a second library, the
OpenBabel(chemistry) shared library, which is also located in 

   /usr/local/pgsql/lib/libopenbabel.so

On the Postgres 8.3 system, I simply put libopenbabel.so into the /usr/local/pgsql/lib directory, and everything worked
well. On 8.4, I can't seem to get it to load libopenbabel.so.  Other programs that use this library have no trouble
findingit. 

What (if anything) has changed from 8.3 to 8.4 regarding how it finds and links dynamic libraries?  What else should I
lookfor?  I'm stumped on this one. 

Thanks,
Craig

pgsql-admin by date:

Previous
From: David Bear
Date:
Subject: Re: postgres data permission
Next
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 to 8.4 - Can't load dynamic shared library