Re: [GENERAL] Checking cursor's state in plpgsql

2005-04-14 Thread Sibtay Abbas
thankz :-) On 4/10/05, Bruce Momjian wrote: > Sibtay Abbas wrote: > > Hello all > > > > Can we check whether a cursor is OPEN or not in plpgsql. > > Like in oracle you can check a CURSOR'S state with %ISOPEN > > > No, but we do have a TODO item: > > o Allow pooled connections to list all

Re: [GENERAL] Checking cursor's state in plpgsql

2005-04-09 Thread Bruce Momjian
Sibtay Abbas wrote: > Hello all > > Can we check whether a cursor is OPEN or not in plpgsql. > Like in oracle you can check a CURSOR'S state with %ISOPEN > No, but we do have a TODO item: o Allow pooled connections to list all open WITH HOLD cursors -- Bruce Momjian