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-07T07:09:59Z

Lists: pgsql-hackers

Attachments

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

On Fri, 6 Aug 2010, James William Pye wrote:

> On Aug 6, 2010, at 4:31 PM, Kris Jurka wrote:
>> <binary-copy-end-v2.patch>
>
> 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.

Kris Jurka