trouble with R postgreSQL
On Thu, 8 May 2003, jobst landgrebe wrote:
since I installed R 1.7.0 on my machines, the interface to postgreSQL does not work anymore. Till now, I used RPgSQL, but because it stopped working,
I tried
Rdbi.PgSQL and DBI, which were both installed easily but did not work: Rdbi.PgSQL could not be loaded via library()
library(Rdbi.PgSQL)
Loading required package: Rdbi
Error in firstlib(which.lib.loc, package) :
Could not load package Rdbi
In addition: Warning message:
There is no package called 'Rdbi' in: library(package, character.only = TRUE,
logical = TRUE, warn.conflicts = warn.conflicts,
Error in library(Rdbi.PgSQL) : .First.lib failed
You do need to install Rdbi *as well*, as the error messaage says: and I think Rdbi is obselete.
And DBI did not allow loading of a postgreSQL driver:
> dbDriver("PostgreSQL")
Error in do.call(as.character(drvName), list(...)) :
couldn't find function "PostgreSQL"
DBI requires another package to provide a driver, and you didn't install one (and AFAIK there is none for PostgreSQL).
Can anyone help me to get to work one of the interfaces with R version 1.7.0? I have postgreSQL 7.2
Well, you could ask their authors: except for DBI (which needs a backend) none of these have current supported versions on CRAN. I can point out that RODBC does work with PostgreSQL 7.2 and R 1.7.0 provided you get a working ODBC driver: see the notes in the RODBC sources.
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595