Thomas Hallgren <thhal(at)mailblocks(dot)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