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