Neil Conway <neilc(at)samurai(dot)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
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
In response to
pgsql-performance by date
|Next:||From: Chris Beecroft||Date: 2006-06-05 19:05:08|
|Subject: Some queries starting to hang|
|Previous:||From: Neil Conway||Date: 2006-06-05 17:52:25|
|Subject: Re: [PERFORM] psql -A (unaligned format) eats too much|
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-06-05 18:57:11|
|Subject: Re: adding new field |
|Previous:||From: Jonah H. Harris||Date: 2006-06-05 18:05:09|
|Subject: Re: adding new field|