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

. How you 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 C

Re: [R] R, PostgresSQL and poor performance

ight want to consider PL/R: http://www.joeconway.com/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:

Re: [R] Advice on large data structures

you want: https://github.com/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 Conw

Re: [R] RPostgreSQL Loading Issues

tion (e.g. /usr/lib), try adding an entry either to /etc/ld.so.conf or a file 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, &

Re: [R] Rlanguage plr and loadiing climatol package

e wrong place to be asking these questions. > There are websites set up to mediate conversations between PL/R users.) Correct. Please see: http://www.joeconway.com/plr/ http://pgfoundry.org/mail/?group_id=1000247 HTH, Joe -- Joe Conway credativ

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

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 nee

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. l

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 in

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 attache