OK. I implemented this functionality. Look at comment in method: PGConnection>>execute: sqlString withRowBlock: aRowBlock

Is possible to add attached changesets to PostgresV2 package? (by Yanni Chiu)

Thanks, pf

On 27.11.2007, at 17:01, Franz Josef Konrad wrote:

This should help you... <http://article.gmane.org/gmane.comp.lang.smalltalk.squeak.general/109157

...

I don't know if there is an API in newer versions from Postgresql where you can query the number in the result set.

Regards, Franz Josef

Petr Fischer schrieb:

...

Hi,

if I call: conn execute: 'select * from one_milion_table' it seems that all table rows are loaded into memory - right?

Is there an easy way to only iterate (do:) result set records without internal loading bulky resultset into some sort of internal arrays?

Thanks, pf

---

Beginners mailing list Beginners@lists.squeakfoundation.org http://lists.squeakfoundation.org/mailman/listinfo/beginners

---

Beginners mailing list Beginners@lists.squeakfoundation.org http://lists.squeakfoundation.org/mailman/listinfo/beginners

Thanks for the enhancement. It seems to me that the implementation is case-specific and could be implemented using the equivalent SQL calls without changing the PostgresV2 code. In any case, the squeaksource project is world writable, so you can add an enhanced version yourself.

What I would like to do at some point is to support V3 protocol, and at the same time, introduce a streaming protocol where the rows would be read using a #next method (so the result rows would stay on the server until they're requested). Also, #cancel would stop reading any further rows from the server.