Message-ID: <5076544E.60307@ringerc.id.au>
Date: Thu, 11 Oct 2012 13:08:30 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120717 Thunderbird/14.0
MIME-Version: 1.0
To: Craig James <cjames@emolecules.com>
CC: pgsql-admin@postgresql.org
Subject: Re: 9.2 won't load C-language function
References: 
 <CAFwQ8reTRHRgfhwQ-yQ+121JBwg67fEwQb677A_-j1CJQCztoA@mail.gmail.com>
In-Reply-To: 
 <CAFwQ8reTRHRgfhwQ-yQ+121JBwg67fEwQb677A_-j1CJQCztoA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 10/11/2012 02:22 AM, Craig James wrote:
> I have a C-language function I've been using on 8.4 for a long time.  On
> 9.2 it won't load:
>
> test=# set search_path = public;
> SET
> test=# 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":
> libopenbabel.so.4: cannot open shared object file: No such file or directory

What does `ldd /usr/local/pgsql/lib/libchmoogle.so` say? What about when 
run under the PostgreSQL user account?

You may need to set LD_LIBRARY_PATH in the Pg startup script, or modify 
ld.so.conf, or re-build your extension with rpath linking enabled.

As for why it worked with 8.4 - I expect you either altered 
LD_LIBRARY_PATH in the 8.4 startup scripts, or maybe the 8.4 version of 
the extension was built with -Wl,-rpath so the paths to required 
libraries were embedded into the extension library.

--
Craig Ringer