Re: Bug in JDBC-Driver? - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Bug in JDBC-Driver?
Date
Msg-id 41C9E5B3.4070403@opencloud.com
Whole thread Raw
In response to Re: Bug in JDBC-Driver?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Kris Jurka wrote:

> I initially thought this was a great idea, but it breaks down when they
> don't use a PreparedStatement and generate a query directly, then we can't
> intervene and adjust things.  The advantage of setting the server to the
> client's timezone is that this will work as expected.

What about the {ts ...} etc escapes for time/date values?
Aren't you meant to use those for the case where you have
literal date values in the query?

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
Next
From: Andrew Lazarus
Date:
Subject: PreparedStatement and setting an array is now broken