similar to: problem installing RdbiPgSQL for 2.4

Hi there, I'm beginner and would like to have mailing list archive to read it offline and don't disturb mailing list. I'd prefer mbox format. Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg at sai.msu.su,

Eric, thanks for quick reply. at first look I thought it is what I need, but, unfortunately, it doesn't applied to original data - it creates new data with loosing original indexes ! I want to keep indexes of original data, but replace original data with $mids of corresponding $breaks. So, if I have z = 1:10, t=hist(z,plot=F) > z [1] 1 2 3 4 5 6 7 8 9 10 > t$breaks [1] 0 2

Hello, is't possible to get excerptions of data frame using some contstraints, something like q1 = q[q$V3<1] ? Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg at sai.msu.su, http://www.sai.msu.su/~megera/ phone:

Hello, for testing & learning purposes I create X11 device and specify layout like layout(c(1,2,3), 3, 1), so I could play with parameters and see several plots at the same time. That works fine until I try to create 4-th plot - all other plots erased. Such behaviour isn't desirable for testing purposes and I'm asking where to look to disable erasing other plots. Regards, Oleg

Hello, is't possible to specify pattern in levels ? > y=c("ff","f","m","mm","fm","mf","ffm","mmf","mmm","fff"); > factor(y) [1] ff f m mm fm mf ffm mmf mmm fff Levels: f ff fff ffm fm m mf mm mmf mmm I want to specify levels using regexp ("f.*","m.*") or use

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 <

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

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

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, Does the Bioconductor library RdbiPgSQL support the POSIXlt and POSIXct (R time format)?. I tried to import an R data frame which had also some columns of class POSIXct into PostgreSQL 7.2.1 with the command dbWriteTable without success. >str(jame) `data.frame': 8123 obs. of 27 variables: $ kat.st : int 1 2 3 4 5 6 7 8 9 10 ... $ ime : Factor w/ 7867 levels

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

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

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

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

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

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,

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