Re: CREATE LANGUAGE workaround - Mailing list pgsql-general

From Scott Marlowe
Subject Re: CREATE LANGUAGE workaround
Date
Msg-id dcc563d10909271134x96169abrfd9d8850a6b8406f@mail.gmail.com
Whole thread Raw
In response to CREATE LANGUAGE workaround  (Martin Gainty <mgainty@hotmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Carlo Camerino
Date:
Subject: Questions On Tablespace
Next
From: InterRob
Date:
Subject: Re: generic modelling of data models; enforcing constraints dynamically...