Re: trouble with trigger/function???

Nelson Ferreira Jr <nelson(at)radix(dot)com(dot)br> writes:
> Below is what you have to do to load PL/pgSQL into a database:
> Pay atention to the plpgsql.so path, if your PostgreSQL is instaled in any
> other plate than /usr/local/pgsql

> CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
> '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

> CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
> HANDLER plpgsql_call_handler
> LANCOMPILER 'PL/pgSQL';

Or just use the "createlang" script, which wraps all that detail up for
you.

Whichever way you do it, you have to be Postgres superuser to do these
CREATEs.

regards, tom lane