Re: Trouble with COPY IN

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
Cc: Kris Jurka <books(at)ejurka(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Samuel Gendler <sgendler(at)ideasculptor(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Trouble with COPY IN
Date: 2010-07-22 17:10:13
Message-ID: alpine.DEB.2.00.1007221807090.8895@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Thu, 22 Jul 2010, Maciek Sakrejda wrote:
> Can you confirm Kris's theory? You should be able to do that by
> starting a binary copy with the CopyManager.copyIn(String), writing
> all your binary data to it, flushing, and then sleeping for a while
> before calling endCopy? If Kris is right, you should get the error
> after the flush before the endCopy. If that's the case, I can take a
> look at doing a patch this weekend. If I'm reading the protocol
> contract right, it ultimately should be fixed in the backend, though.

I can try and reproduce that. However, I will point out that the patch I
sent to the list which delays the reading of the Z does fix the problem.

Matthew

--
Ozzy: Life is full of disappointments.
Millie: No it isn't - I can always fit more in.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Maciek Sakrejda 2010-07-22 17:21:05 Re: Trouble with COPY IN
Previous Message Maciek Sakrejda 2010-07-22 17:03:44 Re: Trouble with COPY IN

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maciek Sakrejda 2010-07-22 17:21:05 Re: Trouble with COPY IN
Previous Message Maciek Sakrejda 2010-07-22 17:03:44 Re: Trouble with COPY IN