[R-sig-DB] handling RS-DBI errors
ggrothendieck at gmail.com
Tue Aug 10 19:11:43 CEST 2010
On Tue, Aug 10, 2010 at 12:50 PM, Homer V Strong <homer.strong at gmail.com> wrote:
> Sorry for not being more specific in my first email. I'm using RPostgreSQL
> and Ubuntu 10.04.
> The problem is not just the error message prints, but also that R seems to
> have no idea that an error occurred at all. An error message prints in spite
> of the silent=T option, and what's much worse, the class of `out' is NULL.
You could try the pgSQL postgresql driver in the RpgSQL package. On
Windows it works for me:
> con <- dbConnect(pgSQL())
> out <- try(dbGetQuery(con, "select * from doesnotexist"), silent = TRUE)
 "R version 2.11.1 Patched (2010-05-31 r52167)"
 "Windows Vista (build 6002) Service Pack 2"
More information about the R-sig-DB