best way to access PgSQL from R?

There was a bug in Rdbi.PgSQL that caused a segfault on releasing the
connection. The C-code returns NULL instead of SEXP. That's not allowed,
but is undocumented (at least at the time).

T.
Hi,

I'm having a problem with R.app on OSX, where it crashes when I invoke  
dbDisconnect(<myPgSQLconnection>).  This may not be a DBI specific  
problem, but I wanted to make sure I was using the right database  
packages to try and isolate why R is crashing.

 From what I've read, DBI does not yet support a PostgresSQL driver, so  
the latest driver is in the Rdbi and Rdbi.PgSQL modules, correct?

This is how I have been accessing PgSQL:

library("chron") #needed for date columns
library("Rdbi")
library("Rdbi.PgSQL")

pcon <-  
dbConnect(PgSQL(),host="localhost",dbname="test",user="postgres",passwor 
d="<mypassword>")

dbListTables(pcon)  #works fine, as do other SQL operations

dbDisconnect(pcon) #causes R to pause, then crash

Can someone confirm whether this is the most up-to-date way to access  
PostgresSQL databases (I'm running PostgresSQL 7.4.2)?

thanks,

Jim M

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://www.stat.math.ethz.ch/mailman/listinfo/r-sig-db
Timothy H. Keitt
Section of Integrative Biology
University of Texas at Austin
http://www.keittlab.org/

best way to access PgSQL from R?

Thread (4 messages)