Postgres Pro
Downloads
Home   >   mailing lists

Re: We don't enforce NO SCROLL cursor restrictions - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: We don't enforce NO SCROLL cursor restrictions
Date
Msg-id e6b5e1c3-71ad-b384-7f6f-0c3f021906d1@postgresfriends.org
Whole thread Raw
In response to We don't enforce NO SCROLL cursor restrictions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: We don't enforce NO SCROLL cursor restrictions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 9/9/21 7:10 PM, Tom Lane wrote:
> We don't actually prevent you from scrolling a NO SCROLL cursor:
> 
> There are probably specific cases where you do get an error,
> but we don't have a blanket you-can't-do-that check.  Should we?


I would say yes.  NO SCROLL means no scrolling; or at least should.

On the other hand, if there is no optimization or other meaningful
difference between SCROLL and NO SCROLL, then we can just document it as
a no-op that is only provided for standard syntax compliance.
-- 
Vik Fearing

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: [Patch] ALTER SYSTEM READ ONLY
Next
From: Tom Lane
Date:
Subject: Re: We don't enforce NO SCROLL cursor restrictions