Hi,
I have got PostgreSQL 8.4 up and running on my Ubuntu Server 64-bit OS, but I am having difficulty with the PL/Python functions from my database. In particular, I am running this:
-------------------------------------------------------
drop language plpythonu cascade;
create language plpythonu;
-- Utility
CREATE OR REPLACE FUNCTION min_float(a float, b float) RETURNS float AS
$$
return min(a,b);
$$ LANGUAGE plpythonu;
SELECT min_float(1,2);
-------------------------------------------------------
And receiving this error message:
-------------------------------------------------------
NOTICE: drop cascades to function min_float(double precision,double
precision)
ERROR: could not load library
"/opt/PostgreSQL/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0:
cannot open shared object file: No such file or directory
********** Error **********
ERROR: could not load library
"/opt/PostgreSQL/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0:
cannot open shared object file: No such file or directory
SQL state: 58P01
-------------------------------------------------------
The strange thing is that I have successfully created plpythonu language and the PLPythonu function(s). I was originally having difficulty getting PL/Python to install and it was throwing a similar error. However, this everntually went away once I added the PostgreSQL root install dir to the PATH variable (in my .bashrc and .bash_profile). I have both Python26 and Python31 installed (both came with ubuntu I believe).
I am not sure that I have put my PATH and LD_LIBRARY_PATH settings into the correct .bash_profile and .bashrc files so that PgAdmin3 and psql (being opened by other users) will have the correct settings.
Any ideas/help much appreciated?
Thanks,
Tom
