At 00:43 09/10/01 +1000, you wrote:
>Could it not just be a feature of pgadmin to allow users to enable
>plpgsql? Enabling the language is, after all, just SQL.
>
>As for having it by default, this takes some level of control out of the
>hands of the administrator. What if you do not want to allow your users to
>create plpgsql functions?
>
>Gavin
Hello Gavin,
Enabling plpgsql language is just SQL, agreed.
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';
But you can never be sure that /usr/local/pgsql/lib/plpgsql.so
is the right path. Maybe a built-in plpgsql_call_handler function would
suffice.
Cheers,
Jean-Michel POURE
