Re: [R] RPostgreSQL segfault with LEFT JOIN

2009-06-08 Thread Dylan Beaudette
On Sunday 07 June 2009, Dirk Eddelbuettel wrote: > On 7 June 2009 at 06:40, Neil Tiffin wrote: > | I am adding your note to google code issues > | (http://code.google.com/p/rpostgresql/issues/list ), issue Number 1. > | Normally I monitor R-SIG-DB > | (https://stat.ethz.ch/mailman/listinfo/r-sig-d

Re: [R] RPostgreSQL segfault with LEFT JOIN

2009-06-07 Thread Dirk Eddelbuettel
On 7 June 2009 at 06:40, Neil Tiffin wrote: | I am adding your note to google code issues (http://code.google.com/p/rpostgresql/issues/list | ), issue Number 1. Normally I monitor R-SIG-DB (https://stat.ethz.ch/mailman/listinfo/r-sig-db | ). That list seems most appropriate. | Hope to look

Re: [R] RPostgreSQL segfault with LEFT JOIN

2009-06-06 Thread Joe Conway
Dylan Beaudette wrote: After some further investigation, I see that the query works fine if I *do not use column aliases* : Looks like *any* query using a column alias will segfault unless the alias exactly matches the column name (in which case why bother). The code starting at line 423 in

Re: [R] RPostgreSQL segfault with LEFT JOIN

2009-06-04 Thread Dylan Beaudette
On Thursday 04 June 2009, Dirk Eddelbuettel wrote: > On 4 June 2009 at 16:17, Dylan Beaudette wrote: > | Hi, > | > | I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched > | to the RPostgreSQL package for interfacing with a postgresql database. I > | am using postgresql 8.3.7. >

Re: [R] RPostgreSQL segfault with LEFT JOIN

2009-06-04 Thread Dirk Eddelbuettel
On 4 June 2009 at 16:17, Dylan Beaudette wrote: | Hi, | | I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the | RPostgreSQL package for interfacing with a postgresql database. I am using | postgresql 8.3.7. | | A query that works from the postgresql terminal is cau

[R] RPostgreSQL segfault with LEFT JOIN

2009-06-04 Thread Dylan Beaudette
Hi, I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the erro