[R-sig-DB] best way to access PgSQL from R?

[Timothy H. Keitt]

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.

On Fri, 2004-07-23 at 12:08, Jim McLoughlin wrote:
> 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 using 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/