From edd at debian.org  Mon Jan 17 15:10:57 2011
From: edd at debian.org (Dirk Eddelbuettel)
Date: Mon, 17 Jan 2011 08:10:57 -0600
Subject: [Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1
	Win64	crash
In-Reply-To: <AANLkTimfKn+qAMP8q2W8nJFvxVdoOM8gYYWZtZU_Jk9w@mail.gmail.com>
References: <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com>
	<AANLkTimfKn+qAMP8q2W8nJFvxVdoOM8gYYWZtZU_Jk9w@mail.gmail.com>
Message-ID: <19764.19953.237115.864920@max.nulle.part>


On 16 January 2011 at 23:00, Xiaobo Gu wrote:
| Is it because of compiler campsites between R and PostgreSQL, R is
| compiled by GCC, while PostgreSQL from Enterprise DB is compiled by
| Microsoft Visual C ++.

So the usual recommendation is to build the matching library (here libpq)
with the same compiler, or get the commercial support you are paying for to
do it for you.  

For what it is worth, I deal with one vendor at work where I made that
requirement and they had no issue complying / helping me with a MinGW /
Rtools-compatible library.  One of several reasons I like working with that
vendor.

Dirk
 
| Xiaobo Gu
| 
| On Sat, Jan 15, 2011 at 10:34 AM, Xiaobo Gu <guxiaobo1982 at gmail.com> wrote:
| > Hi,
| > I build the binary package file of RPostgreSQL 0.1.7 for Windows 2003
| > Server R2 64 bit SP2, the software environments are as following:
| > ? ? ? ? R 2.12.1 for Win64
| > ? ? ? ? RTools212 for Win64
| > ? ? ? ? DBI 0.2.5
| > ? ? ? ? RPostgreSQL 0.1.7
| > ? ? ? ? Postgresql related binaries shipped with
| > postgresql-9.0.2-1-windows_x64.exe from EnterpriseDB
| >
| > The package can be loaded, and driver can be created, but the
| > dbConnect function causes the whole RGui crashes,
| >
| > driver <- dbDriver("PostgreSQL")
| > con <- dbConnect(driver, dbname="demo", host="192.168.8.1",
| > user="postgres", password="postgres", port=5432)
| >
| 
| ______________________________________________
| R-devel at r-project.org mailing list
| https://stat.ethz.ch/mailman/listinfo/r-devel

-- 
Dirk Eddelbuettel | edd at debian.org | http://dirk.eddelbuettel.com



[Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 crash
Dirk Eddelbuettel