[R] unable to load package RPgSQL

[Laurent Faisnel]

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