Re: Postgres 8.2 and setFetchSize

[Frédéric Houbie <fh(at)ionicsoft(dot)com>]

I know, two differents tests on two databases, I know also that setFetchSize limit the number of rows that are returned without waiting the full result list. That's what I want. The fact is that the behaviour is different from my pc (windows XP, pg 8.2.4). 

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

-----Message d'origine-----
De : Oliver Jowett [mailto:oliver(at)opencloud(dot)com] 
Envoyé : mercredi 19 septembre 2007 15:26
À : Frédéric Houbie
Cc : pgsql-jdbc(at)postgresql(dot)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. What can 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