Message-ID: <gh-pgjdbc-pgjdbc-2861-c2225771456@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 12 Jul 2024 14:56:44 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #2861: setFetchSize is ignored?
In-Reply-To: <gh-pgjdbc-pgjdbc-2861@github.com>
References: <gh-pgjdbc-pgjdbc-2861@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 2225771456
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 2861
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/2861#issuecomment-2225771456
Content-Type: text/plain; charset=utf-8

> I wondered if there is any option available to swap the silent fall-back with an exception? I'm well aware of the requirements for getting a cursor but due to abstractions like Hibernate it sometimes isn't obvious where they've been met, and in many of those cases it's preferable to fail fast than to load millions of rows into memory!
> 
> If there isn't currently an option available, does it seem like something that would be accepted as a pull request?

I'd be interested in a PR which implemented `WITH HOLD CURSORS`