Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 27 Jul 2007 05:03:04 -0400 (EDT)
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
- References:
- Prev by Date: Re: Clean up wasNullFlag usage
- Next by Date: Re: SSL support for javax.sql.DataSource
- Previous by thread: Issue with batch update and timestamp escape syntax error
- Next by thread: Updated french translations
- Indexes: