plperl.on_init - bug or just me?
From memory and the thread below, I thought one of the key uses was to
let me use a module from trusted plperl.
http://archives.postgresql.org/pgsql-hackers/2010-02/msg00167.php
The example below has a TestModule that just exports one sub - visible
from plerlu but not plperl. Presumably "Safe" just clamps down and my
sub isn't marked as acceptable. Is this intended, or am I doing
something stupid?
postgresql.conf:
plperl.on_init =
'use lib "/home/richardh/dev/"; use TestModule qw(add_one);'
-- tries to call TestModule::add_one
richardh=# SELECT add_one(1);
ERROR: Undefined subroutine &TestModule::add_one called at line 1.
CONTEXT: PL/Perl function "add_one"
-- tries to call the exported main::add_one
richardh=# SELECT add_one_e(1);
ERROR: Undefined subroutine &main::add_one called at line 1.
CONTEXT: PL/Perl function "add_one_e"
-- plperlu - TestModule::add_one
richardh=# SELECT add_one_u(1);
add_one_u
-----------
2
(1 row)
--
Richard Huxton
Archonet Ltd
Richard Huxton wrote:
From memory and the thread below, I thought one of the key uses was to
let me use a module from trusted plperl.
http://archives.postgresql.org/pgsql-hackers/2010-02/msg00167.phpThe example below has a TestModule that just exports one sub - visible
from plerlu but not plperl. Presumably "Safe" just clamps down and my
sub isn't marked as acceptable. Is this intended, or am I doing
something stupid?
It's intended (at least by me).
Also, please see the recent discussion about loading extra stuff into
the Safe container. At the very least that has been shelved for now.
We're going to proceed with deliberation in this area. I'm quite
concerned to make sure that we don't provide an opportunity for people
to undermine the behaviour of the trusted language.
cheers
andrew
On 25/02/10 17:10, Andrew Dunstan wrote:
Richard Huxton wrote:
Presumably "Safe" just clamps down and my
sub isn't marked as acceptable. Is this intended, or am I doing
something stupid?It's intended (at least by me).
Also, please see the recent discussion about loading extra stuff into
the Safe container.
Ah - looks like I've missed a thread.
At the very least that has been shelved for now.
We're going to proceed with deliberation in this area. I'm quite
concerned to make sure that we don't provide an opportunity for people
to undermine the behaviour of the trusted language.
Fair enough.
--
Richard Huxton
Archonet Ltd