[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