When I did install.packages("sqldf") on Windows and Mac OSX, it installed
fine.
However, when I did it on my Debian Squeeze box under R 2.14.0, it failed.
I discovered that three of the dependent packages, chron, proto, and
gsubfn, do not include a NAMESPACE file in their distribution tar.gz files.
I contacted the developer, who told me that, for packages without a
NAMESPACE file, R 2.14 (but not early versions of R) generates a NAMESPACE
file.

My workaround to get sqldf installed was to copy the generated NAMESPACE
files from my Mac to my Debian squeeze box and use R CMD INSTALL to install
the packages.

Although I read
   "As from R 2.14.0 all packages will be installed with a namespace:
   rather than relying on this mechanism authors are strongly
   encouraged to add a namespace for themselves."
on
   http://cran.r-project.org/doc/manuals/R-exts.html#Package-namespaces
it nevertheless appears to me that this behavior (not generating NAMESPACE
files) is peculiar to my Debian installation (since it worked on the
Windows and Mac machines).

Please let me know if you need more details or further research.

R totally ROCKS!

	[[alternative HTML version deleted]]

