Sort out Mac OS X Errors on R CRAN about rpostgresql HOT 2 CLOSED

January 5, 2010 11:49:07 AM CST

Neil, Dirk,

thanks for your help! I finally managed to compile and install the package. Two 
issues:

* Setting the location of the PG header files as shown on the Wiki page does 
not seem to have any effect. Also, changing the search lists in configure and 
configure.in still gives the same error. Due to my lack of knowledge about 
(auto)configure, I manually override the paths for the libs and includes in 
configure by adding

PG_INCDIR=/Library/PostgresPlus/8.4SS/include
PG_LIBDIR=/Library/PostgresPlus/8.4SS/lib

at around line 2675 (after the directories are tested). These are the paths for 
the EnterprizeDB Postgres Standard Server (8.4) I am using. Compilation now 
starts (but see below). Still, this suggests to me that there is a problem in 
the configure script, which causes the PG_*DIR variables not to be set at all. 
This would also explain why the CRAN version does not compile (with the Fink PG 
libs installed).

* For OS X Users, R needs to be called with the arch flag correctly set, as in

> sudo R --arch=i386 CMD INSTALL RPostgreSQL

The default R call compiles a 64-bit package, but installs it under 32-bit R, 
which results in an error when the package is loaded. Maybe this is worth 
adding to the Wiki.

Thanks again for your work on the package!

Best
Nils

Hopefully fixed in r134.