Re: [R] Error while trying to install RPostgreSQL.

get those depends on how postgres was installed in the first place, and/or what OS/distribution you are using. Since you didn't tell us that it is hard to provide any additional help. Please read the posting guide http://www.R-project.org/posting-guide.html HTH, Joe -- Joe Conway credativ LLC

Re: [R] R, PostgresSQL and poor performance

/plr/ HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read

Re: [R] Advice on large data structures

/jconway/plr The official docs have not been updated yet, but see the pre-release docs here (specifically chapter 9): http://www.joeconway.com/plr/doc/plr-git-US.pdf HTH, Joe *PL/R allows you to execute R functions from within a PostgreSQL database -- Joe Conway credativ LLC: http

Re: [R] RPostgreSQL Loading Issues

with the appropriate entry in /etc/ld.so.conf.d/ and then run ldconfig HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support __ R-help@r-project.org mailing list

Re: [R] Rlanguage plr and loadiing climatol package

, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature __ R-help@r-project.org mailing list https

Re: [R] RPostgreSQL - Unable to locate required modules/DLLs on WinXP/7

On 06/29/2010 03:35 PM, João Gonçalves wrote: Error: package 'RPostgreSQL' could not be loaded exists which makes RPostgreSQL loading to fail. The message appears for any of the following DLLs (that actually exist on X:/PostgreSQL_installation_directory/bin): To solve this problem the

Re: [R] Sampling from a Postgres database

On 01/15/2010 01:49 AM, Bart Joosen wrote: One way could be to first select only the unique ID's, sample this and then select only the relevant records: strQuery = SELECT ID from tblFoo; IDs - sqlQuery(channel, strQuery) sample.IDs - sample(IDs,10) strQuery = paste(SELECT ID from tblFoo

Re: [R] RPostgreSQL: unable to load shared library

Fanfaar wrote: I'm using R 2.9.2 on a WinXP system, and I installed the RPostgreSQL Error: package/namespace load failed for 'RPostgreSQL' I don't suppose DLL should be directly in my PATH, right? Thanks for any hints, I don't use Windows, much, but if I recall correctly the DLLs do need

Re: [R] RPostgreSQL package and libpq.dll file

Lore M wrote: Dear all, I'd like to use the package RPostgreSQL. I'm using R version 2.8.1 and I've download the last version RPostgreSQL. When I load the package, I get something like the file LIBPQ.DLL is missing. Do you have any idea about what I'm suppose to do ? Thanks everyone.

Re: [R] RPostgreSQL segfault with LEFT JOIN

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

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

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