Message-ID: <gh-pgjdbc-pgjdbc-2976-rc1395662507@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 16 Nov 2023 13:03:57 +0000
Subject: Re: [pgjdbc/pgjdbc] PR #2976: feat: fetch size for RefCursor
In-Reply-To: <gh-pgjdbc-pgjdbc-2976-rc1395614149@github.com>
References: <gh-pgjdbc-pgjdbc-2976@github.com> <gh-pgjdbc-pgjdbc-2976-rc1395614149@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 1395662507
X-GitHub-Comment-Type: review_comment
X-GitHub-Commit: 2be046b8c76fcda813f53d5d9070e13feb009dd6
X-GitHub-Issue: 2976
X-GitHub-Line: 185
X-GitHub-Path: pgjdbc/src/test/java/org/postgresql/test/jdbc2/RefCursorTest.java
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: review_comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/2976#discussion_r1395662507
Content-Type: text/plain; charset=utf-8

(on pgjdbc/src/test/java/org/postgresql/test/jdbc2/RefCursorTest.java:185)

Yes, however it is allowed. 
```
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.
```

I don't see a way to change it once we have the statement. Does that currently work with portals ?