Re: Issue with batch update and timestamp escape syntax error - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Issue with batch update and timestamp escape syntax error
Date
Msg-id Pine.BSO.4.64.0707270502100.2617@leary.csoft.net
Whole thread Raw
In response to Issue with batch update and timestamp escape syntax error  ("Hui Ye" <Hui.Ye@STELLENT.COM>)
List pgsql-jdbc

On Thu, 26 Jul 2007, Hui Ye wrote:

> We run into an issue on update query with timestamp in batch execution.
> It appears that following query triggers complaints about "syntax error
> at or about '{'".
> UPDATE testtable SET time = {ts '2007-07-26 10:11:12'} where id = 1;
>

Fixed in CVS for 8.0, 8.1, 8.2 and HEAD.  I will put out a new series of
driver releases this weekend.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Clean up wasNullFlag usage
Next
From: Kris Jurka
Date:
Subject: Re: SSL support for javax.sql.DataSource