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

Re: Trouble with COPY IN

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
Cc: Samuel Gendler <sgendler(at)ideasculptor(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Trouble with COPY IN
Date: 2010-07-20 11:43:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-jdbc
On Tue, 20 Jul 2010, Maciek Sakrejda wrote:
> I'd be willing to take a more in-depth look if you can minimize this
> to a small, at-least-semi-reproducible test case. Ideally, something
> that can be included in
> (since I noticed the driver doesn't have any WITH BINARY tests).

Okay, I'm looking at this now. Just tried running the unit tests (without 
any modifications), and I get a single failure in date handling:

     [junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
     [junit] Tests run: 288, Failures: 0, Errors: 1, Time elapsed: 19.517 sec
     [junit] ------------- Standard Error -----------------
     [junit] DatabaseEncodingTest: Skipping UNICODE database tests as test database encoding is SQL_ASCII
     [junit] ------------- ---------------- ---------------
     [junit] Testcase: testSetDate(org.postgresql.test.jdbc2.DateTest):	Caused an ERROR
     [junit] null
     [junit] java.lang.IllegalArgumentException
     [junit] 	at java.sql.Date.valueOf(
     [junit] 	at org.postgresql.test.jdbc2.DateTest.testSetDate(
     [junit] Test org.postgresql.test.jdbc2.Jdbc2TestSuite FAILED

Will try and produce a test for binary copy in now and let you know how it 


 Most books now say our sun is a star. But it still knows how to change
 back into a sun in the daytime.

In response to


pgsql-hackers by date

Next:From: Marc CousinDate: 2010-07-20 11:47:18
Subject: Re: lock_timeout GUC patch - Review
Previous:From: Pavel StehuleDate: 2010-07-20 11:42:32
Subject: Re: patch: to_string, to_array functions

pgsql-jdbc by date

Next:From: Matthew WakelingDate: 2010-07-20 13:25:29
Subject: Re: Trouble with COPY IN
Previous:From: Maciek SakrejdaDate: 2010-07-20 11:06:02
Subject: Re: Trouble with COPY IN

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