Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
Date
Msg-id 4E3AB6A4.4070708@dunslane.net
Whole thread Raw
In response to Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
List pgsql-hackers

On 08/04/2011 10:28 AM, Tom Lane wrote:
> How can anything like that possibly work with any reliability
> whatsoever?  If the signal comes in, you don't know whether it was
> triggered by the event Postgres expected, or the event the perl module
> expected, and hence there's no way to deliver it to the right signal
> handler (not that the code you're describing is even trying to do that).

True.

> What *I'd* like is a way to prevent libperl from touching the host
> application's signal handlers at all.  Sadly, Perl does not actually
> think of itself as an embedded library, and therefore thinks it owns all
> resources of the process and can diddle them without anybody's
> permission.
>
>             

I'm not sure how perl (or any loadable library) could restrict that in 
loaded C code, which many perl modules call directly or indirectly. It's 
as open as, say, a loadable C function is in Postgres ;-) You have a 
gun. It's loaded. If you point it at your foot and pull the trigger 
don't blame us. I think you just need to be very careful about what you 
do with plperlu. Don't be surprised if things break.

cheers

andrew


pgsql-hackers by date:

Previous
From: Alexey Klyukin
Date:
Subject: Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
Next
From: Merlin Moncure
Date:
Subject: Re: Postgres / plpgsql equivalent to python's getattr() ?