ERROR: creation of Perl function failed: 'require' trapped by operation mask

[Electrorog]

Can anyone help me solve this error? I'm trying to write a function in
Postgres. I do not and cannot install the language plperlu as I am not
a superuser (thinking this may have to do with my problem).

CREATE FUNCTION send_email () RETURNS LANGUAGE plperl AS
$$use Mail::Sendmail;
%mail = (To =>'(e-mail address removed)',
From =>'(e-mail address removed)',
Subject =>'Test',
Message =>"Testing Testing 123\n);
sendmail(%mail) or die $Mail::Sendmail::error;
return;$$;

Thanks!

 

[Ch Lamprecht]

Can anyone help me solve this error? I'm trying to write a function in
Postgres. I do not and cannot install the language plperlu as I am not
a superuser (thinking this may have to do with my problem).

CREATE FUNCTION send_email () RETURNS LANGUAGE plperl AS
$$use Mail::Sendmail;
%mail = (To =>'(e-mail address removed)',
From =>'(e-mail address removed)',
Subject =>'Test',
Message =>"Testing Testing 123\n);
sendmail(%mail) or die $Mail::Sendmail::error;
return;$$;

Hi,
from postgres documentation:

37.5. Trusted and Untrusted PL/Perl

Normally, PL/Perl is installed as a "trusted" programming language named
plperl.
In this setup, certain Perl operations are disabled to preserve security.
In general, the operations that are restricted are those that interact
with the environment.
This includes file handle operations, require, and use (for external
modules).

HTH,
Christoph