Re: [Newbies] PostgresV2 and bulk resultsets

2007-11-28 Thread Yanni Chiu
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

[Newbies] PostgresV2 and bulk resultsets

2007-11-27 Thread Petr Fischer
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 smime.p7s

Re: [Newbies] PostgresV2 and bulk resultsets

2007-11-27 Thread Franz Josef Konrad
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:

Re: [Newbies] PostgresV2 and bulk resultsets

2007-11-27 Thread Petr Fischer
OK. I implemented this functionality. Look at comment in method: PGConnectionexecute: 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...

Re: [Newbies] PostgresV2 and bulk resultsets

2007-11-27 Thread Norbert Hartl
On Tue, 2007-11-27 at 19:23 +0100, Petr Fischer wrote: OK. I implemented this functionality. Look at comment in method: PGConnectionexecute: sqlString withRowBlock: aRowBlock Is possible to add attached changesets to PostgresV2 package? (by Yanni Chiu) Just publish your changes on