[R] crash on multiple queries to postgresql db

[Joe Conway]

Dylan Beaudette wrote:

> Subsequent calls to:
> 
> conn <- dbConnect(PgSQL(), host="localhost", dbname="xxx", user="xxx")
> query <- dbSendQuery(conn, query_text)
> res <- dbGetResult(query) 
> 
> are resulting in this:
> 
> *** glibc detected *** /usr/local/lib/R/bin/exec/R: realloc(): invalid 

> other attached packages:
> [1] RdbiPgSQL_1.8.0 Rdbi_1.8.0      lattice_0.17-20
> 
> Any ideas?

Well, first off, since you are apparently using RdbiPgSQL from 
bioconductor, you should probably try asking there.

But in any case, you might try the latest release from bioconductor:
http://www.bioconductor.org/packages/release/bioc/src/contrib/RdbiPgSQL_1.16.0.tar.gz

or else try the recently released PostgreSQL DBI package on CRAN:
http://cran.stat.ucla.edu/src/contrib/RPostgreSQL_0.1-3.tar.gz

HTH,

Joe