Re: COPY BINARY to STDOUT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY BINARY to STDOUT
Date
Msg-id 2538.960882984@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY BINARY to STDOUT  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Any comments on this?

There is a test in there now to reject COPY BINARY TO STDOUT/FROM STDIN.
If anyone figures out how to support it, the test can be removed...
        regards, tom lane

>> SAKAIDA Masaaki <sakaida@psn.co.jp> writes:
>>>> postgres=# copy binary test to stdout;  <====== error???
>>>> [ psql gets confused ]
>> 
>> Yes, I see it too.  The COPY data protocol is fundamentally textual,
>> so there's no way of making this work without rewriting all our frontend
>> interface libraries.  Not worth it.  I suggest that the backend should
>> reject COPY BINARY commands that are either FROM STDIN or TO STDOUT.
>> Anybody see a better way?


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Proposal for fixing numeric type-resolution issues
Next
From: Tom Lane
Date:
Subject: Re: Proposal for fixing numeric type-resolution issues