On Tue, 2006-08-29 at 18:31 -0400, Tom Lane wrote: > <[EMAIL PROTECTED]> writes: > > here comes the latest version (version 7) of the patch to handle large > > result sets with psql. As previously discussed, a cursor is used > > for SELECT queries when \set FETCH_COUNT some_value > 0 > > Applied with revisions ... I didn't like the fact that the code was > restricted to handle only unaligned output format, so I fixed print.c > to be able to deal with emitting output in sections. This is not > ideal for aligned output mode, because we compute column widths > separately for each FETCH group, but all the other output modes work > nicely. I also did a little hacking to make \timing and pager output > work as expected. > > regards, tom lane
Cool! I specially like that as a side effect of your work for applying this, psql is faster now. Thanks to all people that helped with this (lots...:) Bye, Chris. -- Chris Mair http://www.1006.org ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster