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
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