On Wed, Dec 1, 2021 at 3:52 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:
Also be on the look-out for begin trans; begin trans; etc I read Kumar's report as nested transactions. If your gang is doing a transaction per row, they need a kick in the rear. Anyone not closing those needs a pink slip.
I have seen the second attempt at calling begin seem to be ignored with "WARNING: there is already a transaction in progress" similar to calling rollback without a transaction open. Are you stating or suggesting that calling begin a second time actually is more similar to creating a savepoint? That would be rather unexpected from the messaging, at least for me.
