On Thu, 2010-07-15 at 11:49 -0700, Craig James wrote: > 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 finding it. > > What (if anything) has changed from 8.3 to 8.4 regarding how it finds and links dynamic libraries? What else should I look for? I'm stumped on this one. > Studid question, but did you recompile the library against 8.4 first? > Thanks, > Craig > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin