Re: [ADMIN] 9.2 won't load C-language function

2012-10-11 Thread Craig James
On Wed, Oct 10, 2012 at 10:08 PM, Craig Ringer wrote: > 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

Re: [ADMIN] 9.2 won't load C-language function

2012-10-10 Thread Craig Ringer
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_

Re: [ADMIN] 9.2 won't load C-language function

2012-10-10 Thread Tom Lane
Craig James writes: > ERROR: could not load library "/usr/local/pgsql/lib/libchmoogle.so": > libopenbabel.so.4: cannot open shared object file: No such file or directory > But libopenbabel.so.4 does exist: > # ls -l /usr/local/pgsql/lib/libopenbabel.so.4 > -rwxr-xr-x 1 root root 18250709 2012-1