Re: [R] help regarding RPostgreSQL and R 2.12.2

From: Prof Brian Ripley <>
Date: Mon, 21 Mar 2011 08:09:22 +0000 (GMT)

On Mon, 21 Mar 2011, Shaunak Bangale wrote:

> Prof Ripley,
> Thanks for the first reply. Yes, I am using windows xp.
> The problem that I am facing is:
> I want to use RPostgreSQL and xtable packages together.
> R 2.11.1 has RPostgreSQL but not xtable. R 2.12.2 has xtable but not RPostgreSQL.
> I suppose there should be some way to use RPostgreSQL with R 2.12.2.
> Sorry if I am sounding na´ve, but How do I do the compilation that you just mentioned?
> With your suggestion I went through RW-FAQs , posting guide.

You still haven't followed them! Where is the 'at a minimum' information asked for in the posting guide?

> I ended up at the this page:
> That says: ' Packages related to many database system must be linked to the exact
> version of the database system the user has installed, hence it does
> not make sense to provide binaries for packages '
> PostgreSQL 9.0 is installed on my system which I am trying to integrate with R 2.12.2.
> Please throw some light on what can be done.

You compile from the sources. See and the references therein.

It seems unreasonable (and 'naive') to expect the people who gave you the free gift of R *and* wrote the FAQs to search and read them for you.

In any case, you are simply wrong in your premise: xtable does exist for R 2.11.1 and you could very easily install that from the sources or use

> Thanks
> Shaunak
> -----Original Message-----
> From: Prof Brian Ripley []
> Sent: Friday, March 18, 2011 2:54 PM
> To: Shaunak Bangale
> Cc:
> Subject: Re: [R] help regarding RPostgreSQL and R 2.12.2
> You haven't even told us your OS, but it sounds like it might be
> Windows.
> In any case, RPostgreSQL is (like RMySQL) not distributed in binary
> form, and you need to compile it from the sources against your
> PostgreSQL version (which does matter, including the compiler used to
> build it).
> This is all covered in the rw-FAQ, if this is Windows (see the posting
> guide).
> On Fri, 18 Mar 2011, Shaunak Bangale wrote:
>> Hi R-team,
>> While using R 2.12.2, I came across a problem that it doesn't have RPostgreSQL package in the list of "install packages".
>> As my original code was written in R 2.11.1, I could use the RPostgreSQL package.
>> I am moving to R 2.12.2 to use the newly added package "xtable" in newer version R 2.12.2.
>> Please help me to solve this problem and tell me if the RPostgreSQL package can be added to R 2.12.2.
>> Sooner reply will be appreciated.
>> Thanks in advance.
>> Regards,
>> Shaunak
>> Shaunak Bangale | Innovation Analyst| +91 9986215550|<> |

Brian D. Ripley,        
Professor of Applied Statistics,
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________ mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code.

Received on Mon 21 Mar 2011 - 08:14:51 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 21 Mar 2011 - 08:20:27 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive