Re: [HACKERS] Trouble with COPY IN

Kris Jurka <books@ejurka.com>

From: Kris Jurka <books@ejurka.com>

To: James William Pye <lists@jwp.name>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org, Matthew Wakeling <matthew@flymine.org>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, Maciek Sakrejda <msakrejda@truviso.com>, Samuel Gendler <sgendler@ideasculptor.com>, pgsql-jdbc@postgresql.org

Date: 2010-08-09T18:49:04Z

Lists: pgsql-hackers

Attachments

binary-copy-end-v4.patch (text/plain) patch v4


On Sat, 7 Aug 2010, Kris Jurka wrote:

> On Fri, 6 Aug 2010, James William Pye wrote:
>
>> I think there's a snag in the patch:
>> 
>> postgres=# COPY data FROM '/Users/jwp/DATA.bcopy' WITH BINARY;
>> ERROR:  row field count is -1, expected 1
>> CONTEXT:  COPY data, line 4
>> 
>> Probably a quick/small fix away, I imagine.
>
> Hmm, not quite sure why that is.  That seems to imply that it's not using V3 
> protocol, but I thought binary copy could only be used with the V3 protocol. 
> In any case, I think this new patch is more bulletproof.
>

Oh, duh.  It's a server side copy not going through the client at all. 
Here's a hopefully final patch.

Kris Jurka