Re: plperl and sqrt.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Travis Bauer <trbauer(at)indiana(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plperl and sqrt.
Date: 2001-01-18 01:11:50
Message-ID: 22292.979780310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Travis Bauer <trbauer(at)indiana(dot)edu> writes:
> I have plperl compiled, installed, and generally working on
> Solaris. But when I try to execute the sqrt function, an error
> is issued:
> ERROR: creation of function failed: sqrt trapped by operation
> mask at (eval 10) line 4.

There's an "operation mask" inside plperl that defines which Perl
opcodes it thinks are safe to allow the user to execute. I think
the mask is set pretty conservatively at the moment ... definitely
too conservatively, if it rejects sqrt :-(. But no one's gotten
round to looking at the situation more closely to decide what's
safe and what's not. Feel free to look at the documentation for
Perl's Opcode module and propose a more reasonable mask.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-18 01:14:26 Re: postgres 7.0.3 core dumps
Previous Message Tom Lane 2001-01-18 01:07:23 Re: [SQL] RE: Help with query. (*)