unable to load package RPgSQL
Dirk Eddelbuettel wrote:
On Wed, Apr 16, 2003 at 02:46:56PM +0200, Laurent Faisnel wrote:
I'm trying to install an add-on package for R called RPgSQL. Its role
[...]
* The installation then seemed to be a success :
Not exactly as ...
R CMD INSTALL /home/faisnel/PostGresSql/RPgSQL_1.0-0.tar.gz --configure-args='--with-pgsql-libraries=/usr/local/pgsql/lib --with-pgsql-includes=/usr/local/pgsql/include' * Installing *source* package 'RPgSQL' ... creating cache ./config.cache checking for crypt in -lcrypt... yes checking how to run the C preprocessor... cc -E checking for /usr/include/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /usr/include/pgsql/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /usr/include/postgresql/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /usr/local/include/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /usr/local/include/pgsql/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /usr/local/include/postgresql/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /opt/include/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /opt/include/pgsql/libpq-fe.h... no checking how to run the C preprocessor... cc -E checking for /opt/include/postgresql/libpq-fe.h... no updating cache ./config.cache creating ./config.status creating src/Makevars
... it told you about nine times that a header file is amiss. I would call it a bug in RPgSQL that it even progrsses as it will obviously fail later at the point you noticed. Bottom line: install the required postgresql header files package, and try again. Hth, Dirk
Thank you for your fast help. I desperately tried to install the header files yesterday, but it seemed to me they were already there. The solution was given to me this morning. I had to set an environment variable to the correct value (LD_LIBRARY_PATH), and nothing to install. I gave the path to the libraries, so that the computer could find libpq.so.3, and it worked at once. Laurent