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 AC2739FA5E9 for ; Wed, 31 May 2006 15:50:52 -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 61737-01 for ; Wed, 31 May 2006 15:50:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by postgresql.org (Postfix) with ESMTP id 8D1D29FA5E1 for ; Wed, 31 May 2006 15:50:44 -0300 (ADT) Received: from [192.168.1.227] (68.143.134.146.nw.nuvox.net [68.143.134.146]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id k4VIAHc21472; Wed, 31 May 2006 13:10:17 -0500 Message-ID: <447DE485.6040402@dunslane.net> Date: Wed, 31 May 2006 14:46:29 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.1) Gecko/20060201 SeaMonkey/1.0 MIME-Version: 1.0 To: Andreas Pflug CC: Chris Browne , pgsql-hackers@postgresql.org Subject: Re: Possible TODO item: copy to/from pipe References: <447DC5B4.4080407@pse-consulting.de> <60ac8yt74e.fsf@dba2.int.libertyrms.com> <447DDCC3.7040304@pse-consulting.de> In-Reply-To: <447DDCC3.7040304@pse-consulting.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1342 X-Sequence-Number: 84207 Andreas Pflug wrote: > Chris Browne wrote: >> pgadmin@pse-consulting.de (Andreas Pflug) writes: >> >>> Dave Page wrote: >>> >>>>> -----Original Message----- >>>>> From: pgsql-hackers-owner@postgresql.org >>>>> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Andreas >>>>> Pflug >>>>> Sent: 31 May 2006 16:41 >>>>> Cc: Tom Lane; pgsql-hackers@postgresql.org >>>>> Subject: Re: [HACKERS] Possible TODO item: copy to/from pipe >>>>> >>>>> Andreas Pflug wrote: >>>>> >>>>> >>>>> >>>>>> Won't help too much, until gzip's output is piped back too, so a >>>>>> replacement for COPY .. TO STDOUT COMPRESSED would be >>>>>> COPY ... TO '| /bin/gzip |' STDOUT, to enable clients to >>>>> >>>>> receive the >>>>> >>>>> >>>>>> reduced stuff. >>>>> >>>>> Forgot to mention: >>>>> COPY COMPRESSED was also meant to introduce a portable format >>>>> that's efficient for both text and binary data. Relying on some >>>>> external XYZzip version seems not too portable to me. >>>> >>>> It does have that advantage. Gzip and others are not particularly >>>> Windows friendly for example. >>> >>> ... as most windows programs are pipe agnostic. >> >> >> Shall we make PostgreSQL less powerful because of that? > > I never said that. We shall seek solutions that run painless on most > popular platforms are useful to users. > I wonder if we'd be able to ship gzip with the windows installer, to > insure proper integration. > I wish somebody would explain to me the compelling use case for this. We do not have to build every possible capability into Postgres. As Tony Hoare said, "Inside every large problem is a small problem struggling to get out." This just seems like creeping featurism to me. cheers andrew