Re: Checking cursor's state in plpgsql - Mailing list pgsql-general

From Sibtay Abbas
Subject Re: Checking cursor's state in plpgsql
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Checking cursor's state in plpgsql  (Bruce Momjian <[email protected]>)
List pgsql-general
thankz :-)

On 4/10/05, Bruce Momjian <[email protected]> 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
>   [email protected]               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL 8.0.2 Now Available
Next
From: Mike Rylander
Date:
Subject: Re: psql vs perl prepared inserts