From: Andrew Dunstan <andrew@dunslane.net>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: Chris Browne <cbbrowne@acm.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
Date: Wed, 31 May 2006 14:46:29 -0400
Message-ID: <447DE485.6040402@dunslane.net> (raw)
In-Reply-To: <447DDCC3.7040304@pse-consulting.de>
References: <E7F85A1B5FF8D44C8A1AF6885BC9A0E4013885E9@ratbert.vale-housing.co.uk>
<447DC5B4.4080407@pse-consulting.de>
<60ac8yt74e.fsf@dba2.int.libertyrms.com>
<447DDCC3.7040304@pse-consulting.de>
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
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-hackers@postgresql.org
Cc: andrew@dunslane.net, pgadmin@pse-consulting.de, cbbrowne@acm.org
Subject: Re: Possible TODO item: copy to/from pipe
In-Reply-To: <447DE485.6040402@dunslane.net>
* 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