postgresql question

[I Love Jesus]

I'm not too savvy about postgresql but I got this as a customer request...

Could you please add PL/PGSQL language support for my Postgres database called "username_dxall"? These 2 commands should do the trick as long as your shared object is in the same directory as mine:

CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
AS '/usr/lib/pgsql/plpgsql.so', 'plpgsql_call_handler'
LANGUAGE c;

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;


What is this doing? I already have Apache compiled with PostgreSQL anyway. Is this something different?

Thanks

[hendricknet]

Give this a shot. I had to do this recently for a customer.

http://www.faqs.org/docs/ppbook/c19610.htm