From ripley at stats.ox.ac.uk  Mon Jan 17 18:22:01 2011
From: ripley at stats.ox.ac.uk (Prof Brian Ripley)
Date: Mon, 17 Jan 2011 17:22:01 +0000 (GMT)
Subject: [Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64
 crash
In-Reply-To: <19764.19953.237115.864920@max.nulle.part>
References: <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com>
	<AANLkTimfKn+qAMP8q2W8nJFvxVdoOM8gYYWZtZU_Jk9w@mail.gmail.com>
	<19764.19953.237115.864920@max.nulle.part>
Message-ID: <alpine.LFD.2.00.1101171711170.2906@toucan.stats.ox.ac.uk>

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

Where C (and not C++) is involved it should be possible to mix DLLs 
compiled by MinGW-w64 and MSVC, and this has been done extensively 
(after all a lot of Windows' own DLLs are compiled with MSVC, as are 
the Tcl/Tk binaries which are distributed with R).

>
> 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
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595


[Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 crash
Prof Brian Ripley