Skip site navigation (1) Skip section navigation (2)

Re: Trouble with COPY IN

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
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:03:44
Message-ID: AANLkTinrgKujGBdYWYVFjL3M_xeOKHxVcO8SBH7Rjqdg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
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.
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 230
Foster City, CA 94404
(650) 242-3500 Main
(650) 242-3501 F
www.truviso.com



On Thu, Jul 22, 2010 at 9:38 AM, Matthew Wakeling <matthew(at)flymine(dot)org> wrote:
> On Tue, 20 Jul 2010, Kris Jurka wrote:
>>
>> To me it seems like a protocol violation to receive CommandComplete(C) and
>> ReadyForQuery(Z) before we've issued CopyDone(c) and this should be fixed
>> server side.
>
> Is anyone following this up?
>
> Matthew
>
> --
> If you're thinking "Oh no, this lecturer thinks Turing Machines are a
> feasible
> method of computation, where's the door?", then you are in luck. There are
> some there, there, and by the side there. Oxygen masks will not drop from
> the
> ceiling...                              -- Computer Science Lecturer
>

In response to

Responses

pgsql-hackers by date

Next:From: Matthew WakelingDate: 2010-07-22 17:10:13
Subject: Re: Trouble with COPY IN
Previous:From: vamsi krishnaDate: 2010-07-22 16:38:33
Subject: Copy path in Dynamic programming

pgsql-jdbc by date

Next:From: Matthew WakelingDate: 2010-07-22 17:10:13
Subject: Re: Trouble with COPY IN
Previous:From: Matthew WakelingDate: 2010-07-22 16:38:31
Subject: Re: Trouble with COPY IN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group