On Tue, Aug 14, 2018 at 9:21 AM, Don Seiler <d...@seiler.us> wrote:
> On Mon, Aug 13, 2018 at 5:55 PM, Vick Khera <vi...@khera.org> wrote: > >> On Mon, Aug 13, 2018 at 5:19 PM, Don Seiler <d...@seiler.us> wrote: >> >>> >>> I don't quite follow this. What circumstances would lead to this >>> situation? >>> >> >> BEGIN WORK; >> DECLARE CURSOR ... ; >> FETCH ...; -- for some number of fetches, which does not reach the end >> of the cursor. >> >> then just sit there idle, without having closed the cursor or fetching >> anything more. >> > > So the fix in that case would be to ensure that they CLOSE the cursors > when done with them? > > The general fix is to never sit idle in transaction, but this specific case closing the cursor seems like it will also do it.
