Neil Conway <neilc@samurai.com> writes:
> On Mon, 2006-06-05 at 19:17 +0200, Zoltan Boszormenyi wrote:
>> The general case cannot be applied for all particular cases.
>> E.g. you cannot use cursors from shell scripts
> This could be fixed by adding an option to psql to transparently produce
> SELECT result sets via a cursor.
Note of course that such a thing would push the incomplete-result
problem further upstream. For instance in (hypothetical --cursor
switch)psql --cursor -c "select ..." | myprogram
there would be no very good way for myprogram to find out that it'd
been sent an incomplete result due to error partway through the SELECT.
regards, tom lane