Re: [R] crash on multiple queries to postgresql db [solved]

2009-01-12 Thread Dylan Beaudette
On Mon, Jan 12, 2009 at 6:31 PM, Martin Morgan wrote: > An off-list guess is, ironically, to NOT call dbDisconnect or gc(). > > The C code in the package registers a 'finalizer' that gets called when the > object is garbage collected. This is the same code that gets called by > dbDisconnect. Unfor

Re: [R] crash on multiple queries to postgresql db

2009-01-12 Thread Dylan Beaudette
On Friday 09 January 2009, Joe Conway wrote: > 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 det

Re: [R] crash on multiple queries to postgresql db

2009-01-09 Thread 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 attache