From guxiaobo1982 at gmail.com  Sat Jan 29 10:07:05 2011
From: guxiaobo1982 at gmail.com (Xiaobo Gu)
Date: Sat, 29 Jan 2011 17:07:05 +0800
Subject: [Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64
	crash
In-Reply-To: <alpine.LFD.2.00.1101171711170.2906@toucan.stats.ox.ac.uk>
References: <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com>
	<AANLkTimfKn+qAMP8q2W8nJFvxVdoOM8gYYWZtZU_Jk9w@mail.gmail.com>
	<19764.19953.237115.864920@max.nulle.part>
	<alpine.LFD.2.00.1101171711170.2906@toucan.stats.ox.ac.uk>
Message-ID: <AANLkTinEeqX_3w8qb4_jhfx9Wkmz3GpYZYvVrgZivwG5@mail.gmail.com>

On Tue, Jan 18, 2011 at 1:22 AM, Prof Brian Ripley
<ripley at stats.ox.ac.uk> wrote:
> On Mon, 17 Jan 2011, Dirk Eddelbuettel wrote:
>
>>
>> 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.
>
> And also for what it is worth, RPostgreSQL works for me on x64 Windows 7
> compiled with the Rtools compilers and linked against the initial PostgreSQL
> 9.0 Windows x64 distribution (I've not tried the one you mentioned).

PostgreSQL 9.0.2 source code with a Win64 patch now can be built using
MinGW64 1.0 (GCC 4.5.2), and the RPostgreSQL package works well now
against the corresponding libpq.dll libraries.

By the way, I found MinGW64 with MSYS is much more convenient.

Xiaobo Gu



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