Re: Trouble with COPY IN

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.