Postgres to R date conversion and Writing NULL to postgres database using RpgSQL issue

On Wed, May 11, 2011 at 12:36 AM, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:

On Thu, Apr 21, 2011 at 6:32 AM, subodh agrawal <subodh.iitr at gmail.com> wrote:

Please comment on thses two queries.

1) While converting field of data type "date" selected form postgres,
RpgSQL gives error on windows ?when field value is null.

Thanks. ?This reproduces the error.

library(RpgSQL)
DF <- data.frame(a = c(1, NA, 2), b = c(Sys.Date() + 1:2, NA), c =
c("a", NA, "b"))
con <- dbConnect(pgSQL(), user = "whatever", password = "whatever",
dbname = "whatever")
dbWriteTable(con, "DF", DF)

This is now fixed in the development version of RpgSQL.