Обсуждение: 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.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?
>
>

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