Re: Postgres 8.2 and setFetchSize

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