Re: Error handling in plperl and pltcl

Thomas Hallgren <thhal@mailblocks.com> writes:
> My approach with PL/Java is a bit different. While each SPI call is 
> using a try/catch they are not using a subtransaction. The catch will 
> however set a flag that will ensure two things:

> 1. No more calls can be made from PL/Java to the postgres backend.
> 2. Once PL/Java returns, the error will be re-thrown.

That's what pltcl has always done, and IMHO it pretty well sucks :-(
it's neither intuitive nor useful.
        regards, tom lane