similar to: rdbi segmentation fault (fwd)

hi! i am experiencing the same behaviour explained here: http://finzi.psych.upenn.edu/R/Rhelp02/archive/2482.html (i copied the message below) has anybody found a solution? here is the code that gives me a segmentation fault library(Rdbi) library(Rdbi.PgSQL) conn <- dbConnect(PgSQL(), dbname = "PGA") tmp <- "create table test ( expid int, name varchar(128));"

I can use the Rdbi package to connect to a PostGreSQL server fine but when I use the dbDisconnect(), I get a segmentation error and it throws me out of R. I'm using RH7.2, R1.4.1, Rdbi 0.1-2, and Rdbi.PgSQL 0.1-2. Anyone else seen anything like this and have an possible answer? Andrew Schuh -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing

I have been using RODBC for a while with no complaints (R 2.0.1 patched under WinXP), then I saw a link (http://grass.itc.it/statsgrass/r_and_dbms.html) showing that Rdbi claims to run a query in 5 seconds that takes RODBC 4.3 minutes. That was hard enough for me to believe that I wanted to try some tests myself, but I cannot get Rdbi to connect to my ODBC database. Here is what works for RODBC

Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing

Dear list members, I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or instructions about how to set up the configure scripts? My preliminary efforts to get things going under Windows 2000 haven't met with much success. Thanks, John

To get the Rdbi/RdbiPgSQL 1.0.1 interface from BioConductor functional, I would like to suggest some fixes. Find patches and the updated packages here: http://mpa.itc.it/markus/tmp/rdbi/ Changes Rdbi: - fixed load of RdbiPgSQL (wrong name) - fixed dbConnectionInfo() (typo) RdbiPgSQL: - fixed table export to PostgreSQL - added make.names() to polish column names for R usage

Hi all, I tried to install the Rdbi_0.1-2.tar.gz and Rdbi.PgSQL_0.1-2 package. The Rdbi_0.1-2.tar.gz installed fine but the Rdbi.PgSQL_0.1-2 had some problems. The compilation routine tried to find a header called libpq-fe.h but did not find it in the standard locations. I searched through the computer but did not find a file called in this way either. What should I do to successuffly

Hello, I know that the topics of using large datasets in R vs. SAS, using PostGreSQL vs MySQL, and using databases with R have been discussed extensively on this list and elsewhere. However I hope that I have a slightly new combination of the questions here. I am doing my PhD research on a large dataset and trying to decide whether to use PostgreSQL or MySQL with R, or simply use SAS, to

Hi, I am relatively new at R, but I would like to be able to directly access my MySQL and PostgreSQL databases from R. I have been looking around CRAN and searching through Google, however I am not sure what are the best options. I have seen DBI - not sure how this works Rdbi - not sure how this works Rdbi.PgSQL - can install, but fails on trying to load RODBC - cannot

Sorry for the simple question: What is the "standard" package for interfacing with PostGreSQL (most up-to-date)? There appear to be at least three with different names: Rdbi.PgSQL RdbiPgSQL (available as part of BioConductor) RPgSQL (On the home page, no longer maintained in favor or Rdbi) The R and database developer page (http://developer.r-project.org/db/) was last updated in

I've been putting together a package that defined generic methods for database access. The packages is called "Rdbi." It borrows as much as possible from existing database packages / proposals. I'd like to start a discussion about the proposed interface. Here's what I've come up with so far: # # Rdbi: connectionMethods.R # dbConnect <- function(dbObj, ...)

Hi R-users I recently downloaded RdbiPgSQL 1.8.0 and Rdbi 1.8.0 from Bioconductor to be installed under R 2.4.1. When requiring RdbiPgSQL an error message is showed as follows: > require(RdbiPgSQL) Loading required package: RdbiPgSQL Error in library(package, lib.loc = lib.loc, character.only = TRUE, logical = TRUE, : ‘RdbiPgSQL’ is not a valid package – installed <

A consensus seems to emerge : R would excel to exploratory work on small/middle-sized datasets, while SAS would be able to munch much larger datasets. However, I see the "size" problem as a red herring. The objects that have to stay "in core" are usually much smaller than the dataset. For example, for problems involving fixed-effects linear models, you need only some

Hi, i found tis message in the archive and have got the same problems ? John, perhaps you have found now a way install RPgSQL for windows2000, or anybody other ? many thanks for advance christian [SNIP] I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or

Hi, I just installed ROracle and RDBI. The connection to the database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem? Thank you very much, Mathieu > drv <- dbDriver("Oracle") > summary(drv, verbose=TRUE) <OraDriver:(6721)> Driver name:

Hi, Please excuse these questions if they're obvious. I'm new to R. I need to access a Postgres db from R. I'm currently trying RODBC as I spend part of my time on Windows and rdbi.pgsql seems not to support windows at this time. I unzipped the RODBC win binary download into my library directory and tried to load it using library(RODBC) I get the following error: Error in

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

Hello, I've been trying every now and then to find a cross operating system solution that would let me access PostgreSQL (and PostGIS) from R, or to access R from PostgreSQL. I know of pl/r, which accomplishes the latter, but has yet to be successfully ported to Windows. Similarly, I've tried to use Rdbi and DBI, but I haven't had luck with those on Windows either for connecting to

Dear R-Users, I store my data in an Postgres-table. I can connect with Rdbi.PgSQL, that is no the problem. The problem is the NA-Values. No-data-values are coded as -9999 in the table. But when I extrct them with any SELECT-statement, the -9999-values are treated as normal vectors. How can I tell R not to fetch the datasets containig -9999-values? thanks for your help stephan -- Linux: the

I have a simple vector, called tmp that I want to subset based on another vector called vec. Everything works as expected except for below where the subsetting returns something other than the original data. Any ideas? > vec <- c(1,2,3,4,5,59,60,27,32,21) > tmp [1] 1.0 1.1 2.0 2.1 2.2 3.0 3.1 4.0 5.0 5.1 6.0 7.0 8.0 8.1 9.0 [16] 9.1 9.2 10.0 10.1 11.0 12.0 13.0 14.0