Geert Bevin wrote:
>> Have you turned autocommit off?
>
> No
The driver won't use portal-based resultsets unless you turn off
autocommit. This is because it can't create the equivalent of a WITH
HOLD cursor via protocol-level portals, so any portal created will be
closed at the end of the creating transaction. With autocommit on, the
transaction ends immediately after statement execution, so using a
portal is pointless.
Otherwise it sounds like you meet all the requirements (V3 protocol,
TYPE_FORWARD_ONLY, and fetchsize > 0).
-O