mirror of
https://github.com/hanzoai/postgres.git
synced 2026-10-30 18:33:07 +00:00
Tom Lane
d89902f2ee
Harden hstore_plperl, hstore_plpython, and ltree_plpython against search-path-based attacks by using @extschema:name@ notation to refer to the underlying hstore or ltree data type. This allows removal of the previous documentation warning suggesting that they must be installed in the same schema as the underlying data type. In passing, also improve a para in extend.sgml to suggest using @extschema:name@ for such purposes. Discussion: https://postgr.es/m/[email protected]
18 lines
618 B
SQL
18 lines
618 B
SQL
/* contrib/hstore_plperl/hstore_plperl--1.0.sql */
|
|
|
|
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
|
|
\echo Use "CREATE EXTENSION hstore_plperl" to load this file. \quit
|
|
|
|
CREATE FUNCTION hstore_to_plperl(val internal) RETURNS internal
|
|
LANGUAGE C STRICT IMMUTABLE
|
|
AS 'MODULE_PATHNAME';
|
|
|
|
CREATE FUNCTION plperl_to_hstore(val internal) RETURNS @extschema:hstore@.hstore
|
|
LANGUAGE C STRICT IMMUTABLE
|
|
AS 'MODULE_PATHNAME';
|
|
|
|
CREATE TRANSFORM FOR @extschema:hstore@.hstore LANGUAGE plperl (
|
|
FROM SQL WITH FUNCTION hstore_to_plperl(internal),
|
|
TO SQL WITH FUNCTION plperl_to_hstore(internal)
|
|
);
|