[R] help regarding RPostgreSQL and R 2.12.2

[Shaunak Bangale]

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.
I ended up at the this page: http://cran.r-project.org/bin/windows/contrib/2.12/ReadMe
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.

Thanks
Shaunak




-----Original Message-----
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk]
Sent: Friday, March 18, 2011 2:54 PM
To: Shaunak Bangale
Cc: r-help at R-project.org
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| www.mu-sigma.com<http://www.mu-sigma.com/> |
>
>
>
> ________________________________
> This email message may contain proprietary, private and confidential information. The information transmitted is intended only for the person(s) or entities to which it is addressed. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may be illegal. If you received this in error, please contact the sender and delete the message from your system.
>
> Mu Sigma takes all reasonable steps to ensure that its electronic communications are free from viruses. However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software.
>
>       [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

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

 This email message may contain proprietary, private and confidential information. The information transmitted is intended only for the person(s) or entities to which it is addressed. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may be illegal. If you received this in error, please contact the sender and delete the message from your system.

Mu Sigma takes all reasonable steps to ensure that its electronic communications are free from viruses. However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software.