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

[GENERAL] Checking cursor's state in plpgsql

2005-04-04 Thread Sibtay Abbas
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 After navigating the documentation i was not able to find an equivalent in plpgsql. Do we have an alternative to this in plpgsql? Thankz ---(end