similar to: Rdbi package and PgSQL

one more bit of information about this problem. If I start R as the user "postgres" i dont have the segmentation fault. ---------- Forwarded message ---------- Date: Wed, 5 Feb 2003 19:19:39 -0500 (EST) From: Rafael A. Irizarry <ririzarr at jhsph.edu> Reply-To: rafa at jhu.edu To: "R-Help (E-mail)" <r-help at r-project.org> Subject: rdbi segmentation fault hi! i

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'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, ...)

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

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

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

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

I usually work with R on a windows querying data through RODBC from a postgresql db on a freebsd machine on my offcie lan. Now I have the chance to use R also on a linux gentoo client box and to connect to the same db. I know that I can install the unixodbc stuff and stick to RODBC, BUT my question is: Is there any more 'linuxish' way of querying a postgresql server from a client?

I'm having some issues with using chron() objects for the x-axis in plots. ######### plot(chron(c("07/01/01","08/01/02")),c(100,200),cex.axis=5) ######### It doesn't seem to scale up the cex of the x-axis. Is there any way to scale these x-axis labels up? Also, I'm not sure but I don't believe I have even seen this behavior. #############

Hi everyone, I've just notice a problem with ordered factor variables. It appears that row-binding two ordered factors together looses the ordered attribute. The following example happens both in R1.3.1 and R1.4.1 (on RedHat 7.2): > y <- ordered(gl(3,6),labels=1:3) > y [1] 1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 Levels: 1 < 2 < 3 > data <-

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

Why does 1/0 return Inf? Shouldn't this be returning NaN, NA, or something similar? -- +++++++++++*******+++++***++* Andrew Schuh Environmental Mathematician Neptune and Co. (505) 884-8455 andys at neptuneinc.org +++++++++++*******+++++***++* -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read

I go back and forth from Linux to Windoze often and have to run the same r-scripts. I was wondering why it seems like the default plotting size of labels, symbols, titles, etc seem smaller in Linux than in Windows. Is there a quick way to remedy this so I don't have to manually change the cex settings from 1 to 1.3 every time I go from Windoze to Linux? -- Sincerely,

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

So, i've been writing code in R interfacing with mysql, its been fun and the documentation has been useful, learning quite a bit. the only annoying thing i've been encountering is while coding/debugging, my session gets clogged, especially with sql connections. At the end of the code i dbDisconnect, but when the script is stopped by an error, the session stays open. Usually i'll

Kristoffer R. Munroe wrote: > <ices:Password>hackme</ices:Password> > DEBUG: Mount: /mymp3stream, Password: letmein Are these not significant? -- Tim Schuh Ugly Networks --- >8 ---- List archives: http://www.xiph.org/archives/ icecast project homepage: http://www.icecast.org/ To unsubscribe from this list, send a message to

Dear all!! I am using R1.4.1 on windows 98. I had been trying to organize the package and has already been able to document some of the functions in to .Rd (R documentation) files. From these .Rd files I generated plain text files as well as html files. I have also given the 00Index file in each of the directories: html/ help/ data/ man/ Problem: I don't get the help using comand

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"