From guxiaobo1982 at gmail.com  Sun Jan 16 16:00:41 2011
From: guxiaobo1982 at gmail.com (Xiaobo Gu)
Date: Sun, 16 Jan 2011 23:00:41 +0800
Subject: [Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64
	crash
In-Reply-To: <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com>
References: <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com>
Message-ID: <AANLkTimfKn+qAMP8q2W8nJFvxVdoOM8gYYWZtZU_Jk9w@mail.gmail.com>

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

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



[Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 crash
Xiaobo Gu