Thomas Hallgren <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster