pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hannu Krosing <hannu@skype.net>
Cc: Neil Conway <neilc@samurai.com>
Cc: Zoltan Boszormenyi <zboszor@dunaweb.hu>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Mark Woodward <pgsql@mohawksoft.com>
Cc: Jim C. Nasby <jnasby@pervasive.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [PERFORM] psql -A (unaligned format) eats too much
Date: Tue, 06 Jun 2006 09:48:43 -0400
Message-ID: <15738.1149601723@sss.pgh.pa.us> (raw)
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>

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

view thread (12+ messages)  latest in thread

Message-ID: <15738.1149601723@sss.pgh.pa.us>
Permalink:  ../15738.1149601723@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/15738.1149601723@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, hannu@skype.net, neilc@samurai.com, zboszor@dunaweb.hu, andrew@dunslane.net, pgsql@mohawksoft.com, jnasby@pervasive.com, pgsql-hackers@postgresql.org
  Subject: Re: [PERFORM] psql -A (unaligned format) eats too much
  In-Reply-To: <15738.1149601723@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox