X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 512E09FA5B5 for ; Mon, 5 Jun 2006 15:10:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55961-09 for ; Mon, 5 Jun 2006 15:10:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 69D7E9FA12F for ; Mon, 5 Jun 2006 15:10:36 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k55IAOqJ021821; Mon, 5 Jun 2006 14:10:24 -0400 (EDT) To: Neil Conway cc: Zoltan Boszormenyi , Andrew Dunstan , Mark Woodward , "Jim C. Nasby" , pgsql-hackers@postgresql.org Subject: Re: [PERFORM] psql -A (unaligned format) eats too much In-reply-to: <1149529945.5577.5.camel@localhost> 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> Comments: In-reply-to Neil Conway message dated "Mon, 05 Jun 2006 10:52:25 -0700" Date: Mon, 05 Jun 2006 14:10:24 -0400 Message-ID: <21820.1149531024@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/171 X-Sequence-Number: 84404 Neil Conway 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