Re: [Rd] How to install sqldf to R with version 2.10?

From: Prof Brian Ripley <>
Date: Sat, 17 Mar 2012 16:44:19 +0000

On 17/03/2012 16:25, Uwe Ligges wrote:
> On 17.03.2012 17:20, Joshua Ulrich wrote:
>> On Sat, Mar 17, 2012 at 9:56 AM, zhu free<> wrote:
>>> Hi,
>>> How to install sqldf to R with version 2.10? I used the R in the
>>> cluster of
>>> university and there seems no way to update the R version to 2.14.
>>> However,
>>> I do need sqldf. I tried to install and there is the problem of
>>> namespace.
>>> How could I solve the problem of namespace and run sqldf on R with
>>> version
>>> 2.10? Thank you!
>> Download and unpack the sqldf source, add a NAMESPACE file, then build
>> the Windows binary using R-2.10.x and Rtools210 or Rtools211.
> I don't think the OP is using Windows on a cluster.
> The point is that the new sqldf may not be compatible with the old

And in any case, there is no 'R 2.10', as the posting guide points out.

> release of R - and I don't have such an old version around for testing.
> Anyway: Go to CRAN and the package's archive, you will find old versions
> of the package that may work with the old R-2.10.x

And possibly older versions of all the packages it depends on/imports to.

But, I do have R 2.10.1 around, so I can reproduce the problem:

* installing *source* package sqldf ...
** R
** demo
** inst
** preparing package for lazy loading

Loading required package: proto
Error : package 'gsubfn' does not have a name space ERROR: lazy loading failed for package sqldf

So the unstated problem is that sqldf does not work with gsubfn in R < 2.14.0. And the solution as Uwe said is to use an older version of sqldf (at least).

'zhu free' really does need to study the posting guide at, and learn to post answerable questions.

> Uwe Ligges
>> All these steps are documented throughout the "Writing R Extensions"
>> manual.
>> HTH,
>> --
>> Joshua Ulrich | FOSS Trading:

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
Received on Sat 17 Mar 2012 - 16:47:14 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

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 Sat 17 Mar 2012 - 19:00:30 GMT.

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

list of date sections of archive