I still don't have any idea about your schema [eg CREATE TABLE (blah,
blah, ...);], but I guess you don't have the right database type for
"id" when you are storing a date.
In PostgreSQL:
CREATE TABLE myTable (
id INTEGER PRIMARY KEY,
aDate TIMESTAMP
);
In R:
dbGetQuery(conn, paste("INSE
I just tested your code and I _think_ you have a misconception about
dbWriteTable().
Your code has some oddities so I am only guessing; for example, what is
"zz" and why is it in this snippet?
In the absence of information on the database TABLE, it is even harder
to guess what you are doing,
2 matches
Mail list logo
