I apologize for the first e-mail as I didn't use plain text. Here is the full message. --8<------------------------------------------------------------------------ ------>8--
Hello all! Can someone confirm whether there is a bug or not? I was trying to use sqlUpdate in place of sqlSave as data set I import has duplications. However I get errors while using fast=FALSE argument to safely update/ignore duplicates: Error while executing the query[RODBC] ERROR: Could not SQLExecDirect 'UPDATE "data" SET "logger"=1, "value"=0.0321584 WHERE "time"=2008-09-22 13:15:00' Error in sqlUpdate(con2, na.omit(dat), "data", fast = FALSE) : 42601 7 ERROR: syntax error at or near "13"; It looks like POSIXct class is not escaped properly. I have R 2.12.2 running on Windows XP 32 bit, and I’m using PostgreSQL database. Column time is supposedly of ‘timestamp without time zone’. Here is what I have in the data frame I’m pushing to DB: > class(dat$time) [1] "POSIXct" "POSIXt" Mikhail > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On > Behalf Of Mikhail Titov > Sent: Sunday, August 07, 2011 7:22 PM > To: r-help@r-project.org > Subject: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field? > > Hello all! > > > > Can someone confirm whether there is a bug or not? > > > > I was trying to use sqlUpdate in place of sqlSave as data set I import has > duplications. However I get errors while using fast=FALSE argument to > safely update/ignore duplicates: > > > > Error while executing the query[RODBC] ERROR: Could not SQLExecDirect > 'UPDATE "data" SET "logger"=1, "value"=0.0321584 WHERE "time"=2008-09-22 > 13:15:00' > > Error in sqlUpdate(con2, na.omit(dat), "data", fast = FALSE) : > > 42601 7 ERROR: syntax error at or near "13"; > > > > It looks like POSIXct class is not escaped properly. > > > > I have R 2.12.2 running on Windows XP 32 bit, and Ib ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.