Re: [PERFORM] psql -A (unaligned format) eats too much - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] psql -A (unaligned format) eats too much
Date
Msg-id 15738.1149601723@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] psql -A (unaligned format) eats too much  (Hannu Krosing <hannu@skype.net>)
Responses Re: [PERFORM] psql -A (unaligned format) eats too much  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> Ühel kenal päeval, E, 2006-06-05 kell 14:10, kirjutas Tom Lane:
>> 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.

> would it not learn about it at the point of error ?

No, it would merely see EOF after some number of result rows.  (I'm
assuming you're also using -A -t so that the output is unadorned.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why do we want to %Remove behavior of postmaster -o
Next
From: Martijn van Oosterhout
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work