Re: C libpq frontend library fetchsize - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: C libpq frontend library fetchsize
Date
Msg-id 20100301174740.9975.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to C libpq frontend library fetchsize  (Yeb Havinga <yebhavinga@gmail.com>)
Responses Re: C libpq frontend library fetchsize
List pgsql-hackers
Yeb Havinga <yebhavinga@gmail.com> wrote:

> I'm wondering if there would be community support for adding using the 
> execute message with a rownum > 0 in the c libpq client library, as it 
> is used by the jdbc driver with setFetchSize.

The setFetchSize for libpq is difficult because of the interface
mismatch -- libpq uses array-based APIs (PGresult) and JDBC uses a
cursor-like API (ResultSet). Instead, you can use CURSOR and FETCH
commands to retrieve rows in separated PGresult objects.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: psql with GSS can crash
Next
From: Andrea Suisani
Date:
Subject: Re: Testing of parallel restore with current snapshot