Jan Wieck wrote:
This all would mean that however deeply nested a function call tree,
it would unwind and rollback everything up to the outermost catch. If
there is no catch used, no subtransactions are created and the
unwinding goes all the way up to the statement. If catch is used but
no spi access performed inside, no subtransaction overhead either.
Yes, this makes a lot of sense. No overhead unless you want to. Way to go.
I wish I could do the same in PL/Java.
Regards,
Thomas Hallgren
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend