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? Don. -- Don Seiler www.seiler.us