pl/perl and recent perl versions - failing to load internal modules

From: Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pl/perl and recent perl versions - failing to load internal modules
Date: 2014-07-01 01:47:00
Message-ID: 771945130.305144.1404179220573.JavaMail.zimbra@strategicdata.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I've been trying out PostgreSQL 9.3 with pl/perl built against Ubuntu 14.04 LTS' Perl 5.18
(Sourced from apt.postgresql.org)

Maybe I'm doing something wrong, but it appears that plperl has become completely useless, as it can't load any new modules, but modern Perl versions have refactored the language into lots of small modules that are automatically loaded as required. Except they can't be loaded as required.

For instance, a fairly simple regex will try to load the modules: utf8, utf8_heavy & re
Since it is forbidden from loading anything, it will fail.

You can still use the unrestricted Perl module, plperlu, but this requires superuser permissions to use, and in the past its use has been discouraged.

I've experimented with using the plperl.on_init configuration option to try and include all required modules, but this requires trial-and-error and can easily cause new failures to appear if a stored procedure is changed a little.

Has anyone else encountered this? Am I doing something completely wrong?

Thanks,
Toby

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-07-01 02:59:21 Re: how to create multiple databases running in different dirs
Previous Message Michael Paquier 2014-07-01 00:06:58 Re: lock contention, need profiling idea