similar to: R vs. C

Hi Dirk I think there are problems with pg_config, the configure script of RPostgreSQL checks for pg_config and got ¡°checking for pg_config... /usr/bin/pg_config¡±. In Solaris 10u7 X64, three versions of PostgreSQL are installed, there are in /usr/postgres/8.2(8.2.9) and /usr/postgres/8.3(8.3.3), the corresponding bin files are in /usr/postgres/<version>/bin and

Hi Does anybody know how to create ff objects with data reading from stream objects, such as data reading from PostgreSQL database through RPostgreSQL. For this purpose although we can save the data to a csv file through external tools and then read it through csv readers, but it requires one more data read and write operation, which is of high I/O cost for large datasets. Xiaobo.Gu

Hi, I am using Rattle 2.6.4 with R 2.12.2 on win64, is this a bug ? Following is the content after execute the associate analysis process: Summary of the Apriori Association Rules: Number of Rules: 23351 Summary of the Measures of Interestingness: support confidence lift Min. :0.1250 Min. :1 Min. :2.667 1st Qu.:0.1250 1st Qu.:1 1st Qu.:2.667 Median :0.1250

Hello List, I would like to connect to a postgreSQL database on a remote server and I am wondering what is the best package to do that. I have just installed RpgSQL, RPostgreSQL, Rdbi and RODBC. The handiest to me is RPostgreSQL but I don't see how to connect to a remote server with it. For sure I can connect to remote server with RODBC, but since I am on a Mac OSX 10.6, I have quite

Hi, I am using RpgSQL to retrieve data from a PostgreSQL database wich is with encoding UTF8, and I have some Chinese character in one of the columns, unfortunately R can't show it correctly. > df <- dbGetQuery(con, "select * from test") > df a b 1 1 ????????\xa2 2 2 ???? EURO\xa1 I see the following option, do I need to change the encoding option to show

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 error message, and the R code used to generate the error are listed below. I have noticed that a

I can't get the RPostgreSQL library to load on OSX and have no idea where it's going wrong... > library( RPostgreSQL ) Error in dyn.load(file, DLLpath = DLLpath, ...) : unable to load shared library '/Users/hamannj/Library/R/2.9/library/ RPostgreSQL/libs/i386/RPostgreSQL.so': dlopen(/Users/hamannj/Library/R/2.9/library/RPostgreSQL/libs/i386/ RPostgreSQL.so, 6):

Hi, I'm having trouble connecting to my postgreSQL db on Heroku(Amazon) using RPostgreSQL. I've looked through GitHub for people doing the same thing. There are quite a few examples and all look similar to the below: drv <- dbDriver("PostgreSQL") con <- dbConnect( drv, dbname = "dadqn30er7ghpl", host =

Hi, I am getting the following error while trying to install RPostgreSQL. I tried all three methods(install.packages("RPostgreSQL", type = "source"),install.packages("RPostgreSQL") & R CMD INSTALL RPostgreSQL_0.3-1.tar.gz ) , but none of them is working. ++++++++++++++++++ Error++++++++++++++++++++++++ gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I

Hi Everyone, I'm currently using the latest build of R and R-Studio server (both are amazing products) I'm still very new to this but I came across this issue: I'm trying to do a select from postgres and put the data into and xts object like so: # Libs library('RPostgreSQL') # http://code.google.com/p/rpostgresql/ library('quantmod') library('TTR')

Hi List Apologies if this isn''t the correct place for this query (I''ve tried a search of the mail archives but not had much joy). I''m running R (2.14.0) on a Mac (OSX v 10.5.8, 2.66GHz, 4GB memory) and am having a few performance issues with reading data in from a Postres database (using RPostgreSQL). My query / code are as below # -----------------------------

Hello, I am trying to install RPostgreSQL, but without success at the moment, getting an errormessage - see below. My OS is Fedora 17, R version 2.15.2, PostgreSQL 9.2.1 with Postgis 2.0.1 spatial extension. Thank You for any help, advice or hint in advance. Regards Tomas > install.packages("RPostgreSQL", dependencies=TRUE) trying URL

Hello list, I'm using R 2.9.2 on a WinXP system, and I installed the RPostgreSQL library using the package installer. When trying to load it, I get the following error: > library('RPostgreSQL') Error in inDL(x, as.logical(local), as.logical(now), ...) : unable to load shared library 'C:/PROGRA~1/R/R/library/RPostgreSQL/libs/RPostgreSQL.dll': LoadLibrary failure: The

I'm starting to seriously use R and have tried to solve this issue using my reference books but I'm missing something simple. Running R-2.13.1 on Slackware-13.1. Trying to invoke RPostgreSQL so I can copy data from a postgres table to an R data-frame. I installed RPostgreSQL and the library() command shows it's present: Packages in library

Dear list users, The problem occurs when library(RPostgreSQL) is issued on R. This issue has previously appeared on R mailing list without any robust solution. The error message issued by R: Loading required package: RPostgreSQL Loading required package: DBI Error in inDL(x, as.logical(local), as.logical(now), ...) : unable to load shared library

hello, if i load the RSQLite package in addition to the RPostgreSQL package, i get various errors when trying to use RPostgreSQL functions. here is an example transcript showing one such error: ========================================================== R version 2.15.0 (2012-03-30) [...] > packageVersion('RPostgreSQL') [1] 0.3.2 > packageVersion('RSQLite') [1] 0.11.1

Thanks for the suggestion, but after putting that at the top of the spec and running rpmbuild, I still get Resolving Dependencies --> Running transaction check ---> Package R-RPostgreSQL.x86_64 0:0.4-1.el6 will be installed --> Processing Dependency: /usr/bin/r for package: R-RPostgreSQL-0.4-1.el6.x86_64 --> Processing Dependency: /usr/bin/r for package:

Hi, I am trying to write a function do cast columns of data frame as factor in a loop, the source is : as.factor.loop <- function(df, cols){ if (!is.null(df) && !is.null(cols) && length(cols) > 0) { for(col in cols) { df[[col]] <- as.factor(df[[col]]) } } } source('D:/ambertuil.r') x <- 1:5 y <- 2:6 df <- data.frame(x=x, y=y)

( A similar problem is also reported by Sebastian P. Luque with library(maptools) library(trip) in the vignette as below ). I am writing a vignette which loads RMySQL and RPostgreSQL. This produces the warning: Loading required package: DBI Warning in .simpleDuplicateClass(def, prev) : A specification for class ?dbObjectId? in package ?RPostgreSQL? seems equivalent to one from package

Hi R-team, While using R 2.12.2, I came across a problem that it doesn't have RPostgreSQL package in the list of "install packages". As my original code was written in R 2.11.1, I could use the RPostgreSQL package. I am moving to R 2.12.2 to use the newly added package "xtable" in newer version R 2.12.2. Please help me to solve this problem and tell me if the RPostgreSQL