Re: Error handling in plperl and pltcl - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Error handling in plperl and pltcl
Date
Msg-id 24748.1101849864@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error handling in plperl and pltcl  (James William Pye <flaw@rhid.com>)
Responses Re: Error handling in plperl and pltcl
List pgsql-hackers
James William Pye <flaw@rhid.com> writes:
> plpy being an untrusted language, I *ultimately* do not have control
> over this. I can only specify things within my code. I *cannot* stop a
> user from making an extension module that draws interfaces to those
> routines that may rollback to a savepoint defined by the caller.

In which case, whether it works or not is his problem not yours ;-)
This is a straw-man argument, as is the entire discussion IMHO.
Wrapping each individual SPI command in a subtransaction IN NO WAY
prevents us from adding programmer-controllable savepoint features
to the PL languages later.  It simply ensures that we have somewhat
sane error recovery behavior in the meantime.  The only valid argument
against doing it is the one of added overhead, and I already gave my
responses to that one.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Error handling in plperl and pltcl
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Increasing the length of