2009/9/27 Martin Gainty <mgai...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
