Re: [HACKERS] Trouble with COPY IN - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: [HACKERS] Trouble with COPY IN
Date
Msg-id alpine.BSO.2.00.1008091447440.25873@leary.csoft.net
Whole thread Raw
In response to Re: [HACKERS] Trouble with COPY IN  (Kris Jurka <books@ejurka.com>)
Responses Re: [HACKERS] Trouble with COPY IN  (James William Pye <lists@jwp.name>)
Re: [HACKERS] Trouble with COPY IN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc

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

Attachment

pgsql-jdbc by date:

Previous
From: "Donald Fraser"
Date:
Subject: Re: Java proxies connection to postgres
Next
From: Kris Jurka
Date:
Subject: Re: 9.0 Driver