Re: Postgres 8.2 and setFetchSize - Mailing list pgsql-jdbc

From Frédéric Houbie
Subject Re: Postgres 8.2 and setFetchSize
Date
Msg-id 95484F7A889A61469885286054F675DD512555@altarf.ionicsoft.com
Whole thread Raw
In response to Postgres 8.2 and setFetchSize  (Frédéric Houbie <fh@ionicsoft.com>)
Responses Re: Postgres 8.2 and setFetchSize
Re: Postgres 8.2 and setFetchSize
List pgsql-jdbc
I know, two differents tests on two databases, I know also that setFetchSize limit the number of rows that are returned
withoutwaiting the full result list. That's what I want. The fact is that the behaviour is different from my pc
(windowsXP, pg 8.2.4).  

I don't know where it could come from.
Frédéric

-----Message d'origine-----
De : Oliver Jowett [mailto:oliver@opencloud.com]
Envoyé : mercredi 19 septembre 2007 15:26
À : Frédéric Houbie
Cc : pgsql-jdbc@postgresql.org
Objet : Re: [JDBC] Postgres 8.2 and setFetchSize

Frédéric Houbie wrote:
> I have one more information, I tried the same code using my local Postgres database (on my XP, 8.2.4), it is working.
Whatcan I check on the server to see what's wrong ? 

> 2007-09-19 14:10:51.993  LOG:  duration: 0.000 ms  execute S_2/C_3: SELECT * FROM SValues

That's a different query to what you said before:

>       String q="SELECT a FROM SValues WHERE  Name = 'title'";

so you're not really running the same code, it seems.

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Postgres 8.2 and setFetchSize
Next
From: Oliver Jowett
Date:
Subject: Re: Postgres 8.2 and setFetchSize