Re: CREATE LANGUAGE workaround

2009/9/27 Martin Gainty <mgainty@hotmail.com>:
> I am slowly transferring my Procedures over and came upon this workaround
> implemented by a script which maps the plpgsql (type) to call plpgsql.dll
> pg_finfo_plpgsql_call_handler
>
> # Create a plpgsql handler for plpgsql type
> CREATE FUNCTION pg_finfo_plpgsql_call_handler() RETURNS plpgsql AS
> '/postgres/pgsql/bin/plpgsql.dll' LANGUAGE C;
> CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER
> pg_finfo_plpgsql_call_handler;
>
> is there a system defined script I can run which would map the plpgsql
> handler to the plpgsql type automatically?

On Unix there's a createlang command (run from the CLI, not from psql)
that does this.

createlang plpgsql dbname