[R-sig-DB] best way to access PgSQL from R?
Timothy H. Keitt
tke|tt @end|ng |rom m@||@utex@@@edu
Fri Jul 23 19:38:12 CEST 2004
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/
More information about the R-sig-DB
mailing list