Re: Checking cursor's state in plpgsql

thankz :-)

On 4/10/05, Bruce Momjian <pgman@candle.pha.pa.us> 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 <CURSOR_VAR>%ISOPEN
> >
> No, but we do have a TODO item:
>
>         o Allow pooled connections to list all open WITH HOLD cursors
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>