[R-sig-DB] RpgSQL Install problems [was: RPostgreSQL Row Inserts on Remote Servers]

[Gabor Grothendieck]

On Fri, Aug 6, 2010 at 8:00 PM, Kasper Daniel Hansen
<kasperdanielhansen using gmail.com> wrote:
> I know little to nothing about using JDBC, but the following caught my
> attention:
>
>>> p <- dbDriver("pgSQL")
>> Error in pgSQL() :
>>  Could not find Postgres JDBC driver
>> on/Library/Java/Extensions/postgresql-8.4-701.jdbc4.jar./Library/Framewo
>> rks/Python.framework/Versions/2.6/bin:/Users/a347549/Bin:/Users/a347549/
>> bin:/opt/bin:/usr/local/bin:/usr/local/pgsql/bin:/usr/bin:/bin:/usr/sbin
>> :/sbin:/usr/local/bin:/usr/texbin:/usr/X11/bin/usr/local/pgsql/share/jav
>> a
>
> It seems that the character after jdbc4.jar is a dot "." instead of a
> colon ":".  I have no idea why (or whether it matters), but there
> could be some name mangling somewhere....
>
> Kasper
>

Are you using the latest version of the RpgSQL package -- version
0.1-3.1 released July 24, 2010?  There were some improvements on the
class path searching in that version.