On Tue, Aug 14, 2018 at 8:23 AM, Vick Khera <vivek@khera.org> wrote:
The general fix is to never sit idle in transaction, but this specific case closing the cursor seems like it will also do it.
Of course. I've let development know that they need to sort out why it's left that way. But if they're also NOT closing cursors, that seems like another bad practice to correct.
Would commit/rollback automatically close cursors opened in that transaction?