similar to: RdbiPgSQL and POSIXct

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 <

I just upgraded R to version 2.4.0 and now I can't install packages RdbiPgSQL. I used the same procedure I did for previous versions of R ! Actually, last time I installed RdbiPgSQL day before upgrading but now I got: downloaded 27Kb * Installing *source* package 'RdbiPgSQL' ... creating cache ./config.cache checking for PQconnectdb in -lpq... no I could not find your PostgreSQL

Because my problem involves the RdbiPgSQL package, I sent a message similar to this one to the Bioconductor list. But while awaiting moderator approval of my message (because I am not a member of that list), it occurred to me to send it to R-help as the problem may be more general than just RdbiPgSQL. Here's my situation: I have been using RdbiPgSQL successfully for a year or two. I

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

hello, I wish to create some 3d scatter diagrams visualising different grouped data set by a given field in the database. I tried the scatterplot3d package, as well as the plot3d and scatter3d functions (both within the rgl resp. Rcmdr package). My first question is, whether is it possibe to group data in the scatterplot3d and plot3d, because I did not succeed to use the groups = ...

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

hi, I have been attempting to run this script and am getting some strange results. The script connects to a database and retrieves a series of tables, using sequential sql statements. I have tested all of the sql statements in the PostGreSQL terminal and they all return the desired results. I place each table into a list and run a FOR loop for 'i' in the list. The script generates

Hello everyone! Congratulations by this gorgeous software. My name is Germán Carrillo, I'm writting from Colombia. I don't have much experience with R, reason why I use the R-GUI (version 2.5.1) on Windows. I have some problems with DBI package, I want to connect to PostgreSQL database but I don't know the way to do it. I was reading the DBI manual and I tried write in my R Console

Dear R-helpers, I'm an absolute beginner using both R and PostgreSQL, but now I have to work with both programs. I need to connect R and my Postgres-database, but every attempt so far has failed (I tried using the RpgSQL package as well as RdbiPgSQL, the first, following this manual (http://code.google.com/p/rpostgresql/) didn't find any drivers for the database (step no. 1) whereas the

Graham, nice package this :-)-O. It was easy to set up MySQL but I struggled immensely to get the stock ODBC working with PostgreSQL (8.3), which has been discussed on the mailing list before (Prof Brian): Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing

On Mon, Jan 12, 2009 at 6:31 PM, Martin Morgan <mtmorgan at fhcrc.org> wrote: > An off-list guess is, ironically, to NOT call dbDisconnect or gc(). > > The C code in the package registers a 'finalizer' that gets called when the > object is garbage collected. This is the same code that gets called by > dbDisconnect. Unfortunately, the code does not check to see if

We have a PostgreSQL table with about 400000 records in it. Using either RODBC or RdbiPgSQL, what is the fastest way to update one (or a few) column(s) in a large collection of records? Currently we're sending sql like BEGIN UPDATE table SET col1=value WHERE id=id (repeated thousands of times for different ids) COMMIT and this takes hours to complete. Surely there must be a quicker

Dear All, As some of you in the archive, i am experiencing problems in using RODBC with IODBC on Mac OS X Panther. I am currrently facing two problems. The first one is apparently linked with IODBC (according to returned R error message) although testing the database access from IODBC manager seems to work fine. The second is by far more radical, R purely and simply reports an error ,

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

Greetings - is there any update on a PostgreSQL driver for the DBI package? If not, what's the currently-preferred method of creating a link from a PostgreSQL database and R? Thanks. ---------------------------------------------------------------------- Andrew J Perrin - andrew_perrin (at) unc.edu - http://www.unc.edu/~aperrin Assistant Professor of Sociology; Book Review Editor, _Social

Hi, I have nicely used RdbiPgSQL under 10.5 but now that I run 10.6 I can't get this to work. I am quite sure I will not be the first to have this problem, so can someone please point me somewhere where this has been described or let me have a cookbook? greetings, el

On Sun, 2009-07-26 at 13:17 +0200, Poersching wrote: > stvienna wiener schrieb: > > Hi all, > > > > I am plotting a financial time series, but I need a more detailed X-Axis. > > > > Example: > > x <- zoo(rnorm(1:6000), as.Date("1992-11-11")+c(1:6000)) > > plot(x) > > > > The X-Axis is labeled "1995", "2000"

Good day, I read some data from a PostgreSQL database by a following script: library(Rdbi) library(RdbiPgSQL) # conn becomes an object which contains the DB connection: conn <- dbConnect(PgSQL(), host="localhost", dbname="BVS", user="postgres", password = "*******") query_duj_kal <- dbSendQuery(conn, "select zdroj as well, cas as date, fe2,

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

Pagarbiai Darius Evseicikas ================== UAB "PROGMERA" Maironio g. 3, LT-60149, Raseiniai tel./faks. +370 428 70329 mob. +370 699 97390 ICQ 297832308 Informacija šiame pranešime gali būti konfidenciali. Ji skirta tik asmeniui, kuriam yra adresuota. Jei Jūs nesate tas asmuo (arba atsakingas už šio pranešimo pristatymą tam asmeniui), Jūs negalite skaityti, kopijuoti ar bet kaip