I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm
using PostGres 6.5.x (I know I need to upgrade...but that is another
subject...). So far I've done the following:
create function pgpgsql_call_handler() returns opaque as
'/usr/local/pgsql/lib/plpgsql.so' language 'C';
create procedural language 'plpgsql' handler plpgsql_call_handler
lancompiler 'PL/pgSQL';
I get a successful creation with these...
When I try and execute a function that uses "language 'plpgsql'", I get
the following error:
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
'/usr/local/pgsql/lib/plpgsql.so' failed. (Shared object"libpq.so.2"
not found)
I have verified that these 2 files do exist in the
/usr/local/pgsql/lib/ directory. Their permissions are both rw-r--r--
and owned by pgsql:pgsql
Thoughts?