On Mon, Jun 30, 2014 at 7:47 PM, Toby Corkindale
<toby.corkind...@strategicdata.com.au> wrote:
> 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.
pl/perl should be preloading those modules via "my $a=chr(0x100);
return $a =~ /\\xa9/i". Do you have some example pl/perl code that is
broke? It seems to work for me (I only have 5.20 installed, on this
machine, but I've used 5.18 on 9.2 and 9.3):
$ perl -v
This is perl 5, version 20, subversion 0 (v5.20.0) built for
x86_64-linux-thread-multi
...
$ psql ...
baroque=> select version();
version
─────────────────────────────────────────────────────────────────────────────────────────────────────────
PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.9.0 20140604 (prerelease), 64-bit
(1 row)
Time: 1.033 ms
baroque=> do $$my $a=chr(0x100); return $a =~ /\\xa9/i$$ language plperl;
DO
Time: 1.161 ms
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
