[R-sig-DB] RdbiPgSQL, OS X, and the location of libpq.5.dylib

[Jason Foster]

I'm using a prebuilt Postgres binary which puts things in ...

/Library/PostgreSQL8/lib/libpq.5.0.dylib
/Library/PostgreSQL8/lib/libpq.5.1.dylib
/Library/PostgreSQL8/lib/libpq.5.dylib
/Library/PostgreSQL8/lib/libpq.a
/Library/PostgreSQL8/lib/libpq.dylib

... so when I execute ...

library(RdbiPgSQL)

... I get back some quite sensible errors:

Error in dyn.load(file, DLLpath = DLLpath, ...) :
   unable to load shared library '/Library/Frameworks/R.framework/ 
Resources/library/RdbiPgSQL/libs/i386/RdbiPgSQL.so':
   dlopen(/Library/Frameworks/R.framework/Resources/library/RdbiPgSQL/ 
libs/i386/RdbiPgSQL.so, 6): Library not loaded: /usr/local/pgsql/lib/ 
libpq.5.dylib
   Referenced from: /Library/Frameworks/R.framework/Resources/library/ 
RdbiPgSQL/libs/i386/RdbiPgSQL.so
   Reason: image not found
Error: package/namespace load failed for 'RdbiPgSQL'

I can add some soft links to my system, but I was wondering if there  
was a better way to get things working?

Thanks!

Jason