Re: Issue with batch update and timestamp escape syntax error

From: Kris Jurka <books(at)ejurka(dot)com>
To: Hui Ye <Hui(dot)Ye(at)STELLENT(dot)COM>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Issue with batch update and timestamp escape syntax error
Date: 2007-07-27 09:03:04
Message-ID: Pine.BSO.4.64.0707270502100.2617@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-07-27 09:13:05 Re: SSL support for javax.sql.DataSource
Previous Message Kris Jurka 2007-07-27 08:56:51 Re: Clean up wasNullFlag usage