View Single Post

   
  #2 (permalink)  
Old 04-16-2008, 12:49 AM
Kris Jurka
 
Posts: n/a
Default Re: Issue with batch update and timestamp escape syntaxerror



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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote