FAQ

[PostgreSQL-Hackers] plperl.on_init - bug or just me?

Richard Huxton
Feb 25, 2010 at 11:01 am
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
reply

Search Discussions

2 responses

  • Andrew Dunstan at Feb 25, 2010 at 5:10 pm

    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
  • Richard Huxton at Feb 25, 2010 at 5:14 pm

    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

Related Discussions

Discussion Navigation
viewthread | post

2 users in discussion

Richard Huxton: 2 posts Andrew Dunstan: 1 post