Stack Overflow
Stack Overflow

Questions tagged [plperl]

plperl/plperlu A perl language extension for use within the PostgreSQL object relational database for creating user defined functions.

plperl and plperlu are procedural language extensions that can be used within the PostgreSQL object relational database for creating user-defined functions.

plperl uses a restricted subset of the full perl language functionality to enable a more security aware set of the perl language features for use within PostgreSQL.

plperlu is an less restrictive feature set of the perl language for use within PostgreSQL. plperlu allows the use of feature such as external modules and filesystem access. The use of plperlu should be carefully reviewed for security conscious environments.

38 questions
0
votes
0 answers

plperl; The specified module could not be found Postgres 10 - Windows 10 - Strawberry Perl 5.24

When running the command: CREATE LANGUAGE plperl; I get an error: The specified module could not be found. Running Windows 10 - Postgres 10 - Strawberry Perl 5.24
FuntimeError
  • 1
  • 1
0
votes
1 answer

PERL DBI in PL/PERL in POSTGRESQL

Can I use DBI in a pl/perl function created in Postgresql to select any foreign database? Im getting the error: Unable to laod DBI.pm into plperl (I know that there are oracle foreign data wrappers, but I just need to store the resultset of a select…
guhl
  • 3
  • 2
0
votes
1 answer

Strawberry Perl 5.12 as PostgreSQL 9.0's plperl on win32?

Has anyone had luck with this combination? So far I've gotten the message: ERROR: could not load library "C:/Program Files/PostgreSQL/9.0/lib/plperl.dll": The specified module could not be found. ...to go away by making a copy of perl512.dll and…
Kev
  • 15,899
  • 15
  • 79
  • 112
0
votes
1 answer

Read file and print with postgresql plperl

I want to read file from OS filesystem and print its content as a table. The most preferable way is the using plperl (because there is no need to use temp tables and plperl is builtin by default in most postgres installations). But unfortunately,…
lesovsky
  • 326
  • 2
  • 14
0
votes
0 answers

Not able to install postgresql-plperl-8.4 on Ubuntu Trusty 14.04

I have recently had a problem installing postgresql-plperl-8.4 on the new Ubuntu 14.04 distribution. When I tried to install it, it gave me this error: postgresql-plperl-8.4 depends on libperl5.10 (>= 5.10.1); however: Package libperl5.10 is not…
Jay
  • 1
  • 2
0
votes
1 answer

How to debug plperl script in postgres-8.4 trigger

I am writing the plperl script function for my trigger execution. When INSERT / UPDATE happens ,my plperl script will run , in that I am dynamically forming some query based on event I receive. I wanted to print it in terminal when I do…
Pavunkumar
  • 5,147
  • 14
  • 43
  • 69
0
votes
1 answer

PostgreSQL's plperlu interpreter's @INC and/or cached libraries: separate for different databases?

I have different versions of some libraries I'm developing, and want to, from within various plperl functions I've written, load a certain version based on current_database(). (IIRC using use rather than require is preferred, I think because it…
Kev
  • 15,899
  • 15
  • 79
  • 112
-1
votes
1 answer

Does plperlu reload Perl modules if they change?

If I wrote something in plperlu, and it used a Perl module (e.g. MyModule::Foo), when would that module be reloaded? Does it keep track of them like mod_perl's Apache2::Reload, so that a touch will cause a reinterpretation?
Kev
  • 15,899
  • 15
  • 79
  • 112
1 2
3