DECLARING THE CURSOR WITH HOLD

On 05/21/2013 04:27 PM, Sajeev Mayandi wrote:

Hi,

I am trying to declare a cursor with hold along with NO SCROLL option.
I am getting syntax error. Just wondering if CURSOR WITH HOLD option
supported. My code snip is.

DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
phostmapping;

NOTE: The code is in plpgsql.

Two things.

1) The correct list for questions like this is:

pgsql-general

You can subscribe here:
http://www.postgresql.org/community/lists/subscribe/

2) When you resubmit this post the following information would be helpful:

Postgres version

The actual error message

The DECLARE statement in context, in other words show as much of the
plpgsql code as possible.

Thanks,

Sajeev

--
Adrian Klaver
adrian.klaver@gmail.com

--
Sent via pgus-general mailing list (pgus-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgus-general

Hi,

I am trying to declare a cursor with hold along with NO SCROLL option. I am getting syntax error. Just wondering if CURSOR WITH HOLD option supported. My code snip is.

DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from phostmapping;

NOTE: The code is in plpgsql and postgresql version is 9.2.

Thanks,

Sajeev

Hello

2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.com>:

Hi,

I am trying to declare a cursor with hold along with NO SCROLL option. I
am getting syntax error. Just wondering if CURSOR WITH HOLD option
supported. My code snip is.

DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
phostmapping;

NOTE: The code is in plpgsql and postgresql version is 9.2.

holdable cursors are not supported in plpgsql

Regards

Pavel Stehule

Thanks,

Sajeev

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Is there a work around to declare the cursor with hold?

Thanks,

Sajeev

On 5/22/13 10:19 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote:

Hello

2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.com>:

Hi,

I am trying to declare a cursor with hold along with NO SCROLL option.
I
am getting syntax error. Just wondering if CURSOR WITH HOLD option
supported. My code snip is.

DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
phostmapping;

NOTE: The code is in plpgsql and postgresql version is 9.2.

holdable cursors are not supported in plpgsql

Regards

Pavel Stehule

Thanks,

Sajeev

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Maybe refcursors ??

All what you can do with cursors is described in
http://www.postgresql.org/docs/9.3/static/plpgsql-cursors.html

Regards

Pavel

2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.com>:

Is there a work around to declare the cursor with hold?

Thanks,

Sajeev

On 5/22/13 10:19 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote:

Hello

2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.com>:

Hi,

I am trying to declare a cursor with hold along with NO SCROLL option.
I
am getting syntax error. Just wondering if CURSOR WITH HOLD option
supported. My code snip is.

DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
phostmapping;

NOTE: The code is in plpgsql and postgresql version is 9.2.

holdable cursors are not supported in plpgsql

Regards

Pavel Stehule

Thanks,

Sajeev

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general