similar to: Package RPostgreSQL : Problem with dbWriteTable

Hello, I use R in batch mode. Each time, I execute a script, R is loading each packages I need in my script. That's Ok But, I had to execute many scripts , and each time R is re-loading the corresponding packages, which take to much time Is it possible ask R to load the packages only once, and stay in memory in background for further scripts, which would avoid to load the packages in

Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?... Nom : non disponible URL : <https://stat.ethz.ch/pipermail/r-help/attachments/20081104/b667d8da/attachment.pl>

Dear R User's Please help me to debug this issue. I am trying to write some data ( i= 6) to PostgreSQL database, but it not writing. Is there any issue in the way I use "dbWriteTable"? ++++++++++++++++++ Source Code ++++++++++++++++++++++++ library("DBI") library("RPostgreSQL") drv1 <- dbDriver("PostgreSQL") i=6 connAE1 <- dbConnect(drv1,host

Hi, I'd like to make a legend with a mix of mathematical symbol (tau), numeric variable and character variables.I have tried : types<-c("Type 1","Type 2","Type 2") tau<-c(1,3,2) legend(x="topright",legend=paste(types,"tau=",expression(tau))) but it doesn't work: the 'tau' symbol is not written in its 'symbol

Hi Tomas, Many thanks for your answer. Here is a copy of a fresh session under RStudio, and after a copy under Rgui. Strangely enough the result of memory.limit() is not the same. Without your question I would not have looked to RGui, being used to work with RStudio. The value under RGui sounds to correspond to the total RAM of the computer. It makes me noticing that the value is in MB.

Hi, I am not not sure whether this topic belongs to this mail list, but I feel the subscribers here should be the right audience. I noticed that the memory limit reported under Windows is 16 GB. I am wondering how to increase it. I didn't found anything in Rprofile.site nor .Rprofile. Is this limit hard coded at compilation? Best, Samuel [[alternative HTML version deleted]]

Dear list, I have encountered a special case for searching a linear regression where I'm not satisfied with the results obtained using the traditional least squares method (sometimes called OLS) for estimating/optimizing the residues to the regression line (see code below). Basically, a group of my x-y data are a bit off the diagonal line (in my case the diagonal represents the ideal or

Dear list, I?m using R embedded in another program (coded in tcl/tk) under Windows Vista. In this context I don?t launch Rgui.exe but rather Rtem.exe. Now I have a problem finding libraries not specifically installed as administrator (and which are not in the path ?program files? but in Contacts\Documents of the current user). To be precise, the user launching my tcl/tk program can?t find

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

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

Full_Name: Zivan Karaman Version: 2.7.2 OS: Windows XP Submission from: (NULL) (195.6.68.214) I'm puzzled by the readRegistry function. Shouldn't the "hive" argument be something like c("HLM", "HCR", "HCU", "HU", "HCC", "HPD") rather than c("HLM", "HCR", "HCU", "HU",

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

Hi, Until now I can no longer connect to my samba domain. I don't know what happened. What this ( below in the log) means: dump workgroup on subnet UNICAST_SUBNET: netmask= 192.168.10.253: Nov 22 13:20:30 localhost nmbd.bis[3275]: #*011ETUDIANT(1) current master browser = UNKNOWN *Some help ? here is the log: announce_myself_to_domain_master_browser: t (1258892410) -

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

RPostgreSQL version 0.1.0 We are pround to announce the availability of the RPostgreSQL package on CRAN and its mirrors. This package provides an a DBI-compliant interface between PostgreSQL and R. RPostgreSQL was developed as part of the Google Summer of Code 2008 program by Sameer Kumar Prayaga. Some highlights: o Implemented all the DBI features o Added support for transaction

Dear all, I'm an absolute R-beginner and want to connect to my PostgreSQL DB (on my local Mac OSX 10.6). 1) I tried to install RPostgreSQL (Package Installer > CRAN (sources)) and get this log below. There seems to be an issue with libpq, bug I don't have any clue how to fix this. What can I do? 2) Once this issue is solved, should this code work? drv <-

RPostgreSQL version 0.1.0 We are pround to announce the availability of the RPostgreSQL package on CRAN and its mirrors. This package provides an a DBI-compliant interface between PostgreSQL and R. RPostgreSQL was developed as part of the Google Summer of Code 2008 program by Sameer Kumar Prayaga. Some highlights: o Implemented all the DBI features o Added support for transaction

Dear all, I'd like to use the package RPostgreSQL. I'm using R version 2.8.1 and I've download the last version RPostgreSQL. When I load the package, I get something like "the file LIBPQ.DLL is missing". Do you have any idea about what I'm suppose to do ? Thanks everyone. _________________________________________________________________ [[elided Hotmail spam]]

Hi Everybody I use R2.9.2 on Mac OS X 10.5.2. I tried to install RPostgreSQL from source on CRAN via the package installer. Apparently the program cannot find my C compiler gcc . Here is the output message trying URL ' http://cran.za.r-project.org/src/contrib/RPostgreSQL_0.1-6.tar.gz' Content type 'application/x-gzip' length 141399 bytes (138 Kb) opened URL

Hi, I've just started using RPostgreSQL within R to interrogate a PostgreSQL database. The problem I have is that a column containing dates shows up differently in R than in the database: here is the output direct from the psql database in Linux: db=> select pat_dob_dt from patients where pat_dob_dt like '%1980'; pat_dob_dt ------------ 04/05/1980 01/12/1980 04/05/1980