[Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 crash
Prof Brian Ripley
ripley at stats.ox.ac.uk
Mon Jan 17 18:22:01 CET 2011
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
More information about the R-devel
mailing list