Re: BUG #5066: plperl issues with perl_destruct() and END blocks - Mailing list pgsql-bugs

David Fetter <david@fetter.org> writes:
> On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
>>> With connection poolers, backends can last quite awhile.  Is it OK
>>> for the END block to run hours after the rest of the code?
>>
>> This is an interesting point -- should END blocks be called on
>> DISCARD ALL?

> ENOCLUE

And in the same vein, should they be called inside a transaction,
or not?  What if they fail?

I don't see any reason whatsoever that we couldn't just document this
as a Perl feature not supported in plperl.  If you do something like
creating threads inside plperl, we're going to give you the raspberry
when you complain about it breaking.  END blocks can perfectly well
go into the same category.

            regards, tom lane