Re: cursors: SCROLL default, error messages - Mailing list pgsql-hackers

From Tom Lane
Subject Re: cursors: SCROLL default, error messages
Date
Msg-id 13982.1048268008@sss.pgh.pa.us
Whole thread Raw
In response to Re: cursors: SCROLL default, error messages  (Neil Conway <neilc@samurai.com>)
Responses Re: cursors: SCROLL default, error messages  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> On Fri, 2003-03-21 at 12:12, Tom Lane wrote:
>> (No problem here with adding the noise-word option, of course.)

> Note that it won't be a noise word: if NO SCROLL is specified, an
> attempt to do a backward fetch on a non-scrollable cursor will yield an
> error.

Hm.  We could imagine a three-way option:NO SCROLL    always error if fetch backwards<nothing>    allow if plan
supportsitSCROLL        allow, add overhead if needed to support
 
The <nothing> case would deviate from the spec but would give backwards
compatibility.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: cursors: SCROLL default, error messages
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Roadmap for FE/BE protocol redesign