Re: plperl security - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: plperl security
Date
Msg-id 40EBF882.5040403@dunslane.net
Whole thread Raw
In response to Re: plperl security  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: plperl security  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:

>
>Recovering when you get an error is probably the trickiest part of this.
>  
>

OK, I have a setup that instead of refusing to load trusted functions if 
the Safe version is not up to date, forces them to error out by calling 
elog(ERROR...), thus:

andrew=# select tval();
ERROR:  trusted perl functions disabled - please upgrade perl Safe 
module to at least 2.09

This seems like perfectly reasonable recovery to me. Thoughts?

cheers

andrew





pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Point in Time Recovery
Next
From: "Scott Marlowe"
Date:
Subject: Re: Nested Transactions, Abort All