To: Hannu Krosing <hannu@skype.net>
cc: Neil Conway <neilc@samurai.com>, Zoltan Boszormenyi <zboszor@dunaweb.hu>,
	Andrew Dunstan <andrew@dunslane.net>, Mark Woodward <pgsql@mohawksoft.com>,
	"Jim C. Nasby" <jnasby@pervasive.com>, pgsql-hackers@postgresql.org
Subject: Re: [PERFORM] psql -A (unaligned format) eats too much 
In-reply-to: <1149597013.3818.7.camel@localhost.localdomain> 
References: <44835834.2020309@dunaweb.hu> <44835F86.5040008@dunaweb.hu>
	<20060605152258.GT53487@pervasive.com>
	<20512.1149521250@sss.pgh.pa.us>
	<20060605155349.GU53487@pervasive.com>
	<20813.1149523235@sss.pgh.pa.us>
	<18006.24.91.171.78.1149526092.squirrel@mail.mohawksoft.com>
	<44845E86.3080001@dunslane.net> <4484672B.8080606@dunaweb.hu>
	<1149529945.5577.5.camel@localhost>
	<21820.1149531024@sss.pgh.pa.us>
	<1149597013.3818.7.camel@localhost.localdomain>
Comments: In-reply-to Hannu Krosing <hannu@skype.net>
	message dated "Tue, 06 Jun 2006 15:30:12 +0300"
Date: Tue, 06 Jun 2006 09:48:43 -0400
Message-ID: <15738.1149601723@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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