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: alpine.DEB.2.00.1007201229110.8895@aragorn.flymine.org (view raw or flat)
Thread:
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
> http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbc/pgjdbc/org/postgresql/test/jdbc2/CopyTest.java
> (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:

runtest:
     [junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
     [junit] Tests run: 288, Failures: 0, Errors: 1, Time elapsed: 19.517 sec
     [junit]
     [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(Date.java:138)
     [junit] 	at org.postgresql.test.jdbc2.DateTest.testSetDate(DateTest.java:120)
     [junit]
     [junit]
     [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 
goes.

Matthew

-- 
 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

Responses

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-2014 The PostgreSQL Global Development Group