[R] postgres/R access problems

ripley@stats.ox.ac.uk ripley at stats.ox.ac.uk
Sun Feb 9 23:25:03 CET 2003


I was asking about which R *package* and version: R itself does not
interface to any DBMS, but there are several ways to interface to PgSQL
and they are *packages* like RPgSQL, which has different versions in
different repositories (although AFAIK none are current on CRAN).
(There is also a dbi.something package.)

That's the vital piece of information: db.connect is not a part of R per 
se, and that seems to be where the problem is.

On 10 Feb 2003, Brendan Murray wrote:

> On Mon, 2003-02-10 at 10:01, Prof Brian D Ripley wrote:
> > On 10 Feb 2003, Brendan Murray wrote:
> > 
> > > I have a problem that has exhausted my ingenuity and would like pointers
> > > to a solution, or at least where to debug.
> > >
> > > - I am using R and postgresql.
> > 
> > And which R package are you using, which version, from which repository?
> 
> $ R --version
> R 1.5.1 (2002-06-17).
> $ /usr/local/pgsql/bin/psql --version
> psql (PostgreSQL) 7.2.1
> 
> repository? I didn't install this originally so I don't know where it 
> came from. The chap that did has left
> 
> Perhaps  the R version is a little past its use-by, but if nobody has
> ever seen the error before then upgrading isn't necessarily going to fix
> it. It will be my next step if nobody can give me some idea of what
> isn't working.
> 
> 
> 
> 
> 

-- 
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




More information about the R-help mailing list