similar to: RPostgreSQL [Expired connection at startup]

This is the first time that I have tried to update packages with a tinkered around with .Rprofile. I start R with R --vanilla and it does not load my .Rprofile, but when I issue the command update.packages() R downloads the packages as expected, but then seems to load .Rprofile before compiling the packages sources. What am I doing wrong? kindest regards, Stephen Sefick see- Session info

I know this is a double post, but the subject line was really misleading. Sorry again. This is the first time that I have tried to update packages with a tinkered around with .Rprofile. I start R with R --vanilla and it does not load my .Rprofile, but when I issue the command update.packages() R downloads the packages as expected, but then seems to load .Rprofile before compiling the packages

hello, if i load the RSQLite package in addition to the RPostgreSQL package, i get various errors when trying to use RPostgreSQL functions. here is an example transcript showing one such error: ========================================================== R version 2.15.0 (2012-03-30) [...] > packageVersion('RPostgreSQL') [1] 0.3.2 > packageVersion('RSQLite') [1] 0.11.1

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

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 recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the error message, and the R code used to generate the error are listed below. I have noticed that a

Hi Dirk I think there are problems with pg_config, the configure script of RPostgreSQL checks for pg_config and got ¡°checking for pg_config... /usr/bin/pg_config¡±. In Solaris 10u7 X64, three versions of PostgreSQL are installed, there are in /usr/postgres/8.2(8.2.9) and /usr/postgres/8.3(8.3.3), the corresponding bin files are in /usr/postgres/<version>/bin and

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/20100507/f5128631/attachment.pl>

Hi all, > library(rgl) > plot3d(1,1,1) > snapshot3d("somefile.png") Error in rgl.snapshot(...) : pixmap save format not supported in this build Why does this no longer work? thanks, Remko > sessionInfo() R version 2.12.0 (2010-10-15) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_Australia.1252 LC_CTYPE=English_Australia.1252 [3]

Is my understanding correct that the body() function currently can't return a function's body intact, in order, and as characters ready for editing? My testing and reading of body()'s help indicate that it can not. Here's what I'm seeing. Consider pasting 1+ and a function containing x^2 together to get 1+x^2 As you can see below, body() reports three

Hi, I received a bug report from a French user who told me there was something wrong with the function packageVersion(), but packageDescription() worked well. Below is the session info; I'm not sure if other French users can reproduce the error message: > packageVersion('base') Erreur : sp?cification de version incorrecte base > sessionInfo() R version 2.12.1 (2010-12-16)

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

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

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, 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

Dear all, I am stuck trying to get RPostgreSQL running on my Mac. PostgreSQL itself does work fine as it is able to connect with various other apps. Unfortunately the RPostgreSQL package is not available as a binary for MAC OS. Thus I?ve been trying to compile the source for quite some time now - unfortunately without success (or at least very limited success). First, running

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

Hi - I have a simple R script that inserts values into a Postgres table to generate a record that autogenerates a bigint unique ID (basically, a customized bigserial value). When I query the table to retrieve the bigint value, the value returned is not the same as the value created in the database (as evidenced by a direct query of the database table via pgAdmin). e.g. the value created should