Re: Trouble with COPY IN

Matthew Wakeling <matthew@flymine.org>

From: Matthew Wakeling <matthew@flymine.org>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Maciek Sakrejda <msakrejda@truviso.com>, Samuel Gendler <sgendler@ideasculptor.com>, pgsql-jdbc@postgresql.org
Date: 2010-07-20T13:56:49Z
Lists: pgsql-hackers
On Tue, 20 Jul 2010, Kevin Grittner wrote:
> Matthew Wakeling <matthew@flymine.org> wrote:
>
>> Just written a test that writes 100000 rows into the test table
>> using  binary copy, and it works perfectly. Not sure what's going
>> on here, as it still fails in my application.
>
> Random thought: is SSL involved in one and not the other?

No.

After a little more investigation, it appears that 
core.v3.QueryExecutorImpl.unlock() is being called before 
core.v3.QueryExecutorImpl.endCopy(), in 
core.v3.QueryExecutorImpl.processCopyResults() apparently because it 
receives a "Z", called by core.v3.QueryExecutorImpl.writeToCopy(). 
Investigating further.

Matthew

-- 
 I quite understand I'm doing algebra on the blackboard and the usual response
 is to throw objects...  If you're going to freak out... wait until party time
 and invite me along                     -- Computer Science Lecturer