attempt at manipulating autoCommit modes around transaction commits to make postgres happy