Re: Options for protocol level cursors

From: James William Pye <pgsql(at)jwp(dot)name>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Options for protocol level cursors
Date: 2008-06-12 17:16:13
Message-ID: 142CED17-AEFE-4002-BC62-58D107E29589@jwp.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Jun 12, 2008, at 10:08 AM, Tom Lane wrote:

> James William Pye <pgsql(at)jwp(dot)name> writes:
>> Is there anyway to bind a cursor with SCROLL and WITH HOLD at the
>> protocol level?
>
> No, and for at least the first of those I don't see the point,
> since the protocol doesn't offer any behavior other than forward
> fetch.

That protocol level inability doesn't keep you from using MOVE on
cursor's name.
And yes, it yield the appropriate errors when you try to MOVE
backwards on a protocol declared cursor.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-06-12 17:25:50 Re: Overhauling GUCS
Previous Message Tom Lane 2008-06-12 17:08:19 Re: Options for protocol level cursors