[postgis-devel] automatic pl/pgsql language creation

strk strk at keybit.net
Fri Jun 11 04:51:59 PDT 2004


What people think about adding automatic pl/pgsql language creation
in postgis.sql ? It's a 2/3 queries we could put outside of
transaction to allow for 'already defined' errors..

CREATE FUNCTION "plpgsql_call_handler" ()
RETURNS language_handler
AS '$libdir/plpgsql' LANGUAGE C;

-- This might need a switch on USE_VERSION
CREATE FUNCTION "plpgsql_validator" (oid)
RETURNS void
AS '$libdir/plpgsql' LANGUAGE C;

CREATE TRUSTED LANGUAGE "plpgsql"
HANDLER "plpgsql_call_handler
VALIDATOR "plpgsql_validator; -- This might need a switch on USE_VERSION

BEGIN;
...

--strk;



More information about the postgis-devel mailing list