Skip site navigation (1) Skip section navigation (2)

Re: 9.2 beta1 libxml2 can't be loaded on Windows

From: Edmund Horner <ejrh00(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 9.2 beta1 libxml2 can't be loaded on Windows
Date: 2012-06-01 00:14:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On 31 May 2012 14:14, Edmund Horner <ejrh00(at)gmail(dot)com> wrote:
> Hello, apologies if this is already in your radar.
> I can successfully install the PostgreSQL 9.2 beta1 binaries on
> Windows XP and successfully perform most queries.  However I've run
> into some trouble with the XML support.
> From a very cursory search I did not see anything changed since 9.1.3
> that could affect this, so maybe it's just a build/packaging issue.
> Cheers,
> Edmund.
> Version and environment:
> PostgreSQL 9.2 beta1, binaries-only package
> Windows XP SP3 32 bit
> Steps:
>  1. Install binaries.
>  2. Start server.
>  3. Open psql session to postgres database.
>  4. Run query:  SELECT xml '<foo>bar</foo>';
> Expected result:  query returns a single row like:
>           xml
>    ----------------
>     <foo>bar</foo>
> Actual result:
>    postgres=# SELECT xml '<foo>bar</foo>';
>    ERROR:  could not set up XML error handler
>    LINE 1: select xml '<foo>bar</foo>';
>                       ^
>    HINT:  This probably indicates that the version of libxml2 being
> used is not compatible with the
>     libxml2 header files that PostgreSQL was built with.
> postgres.exe does find and read part of libxml2.dll both at initial
> server startup, and when psql connects for the first time.

I tried using an older libxml2.dll.  Replace with the one from
(and copying zlib1.dll to zlib.dll), and it works.

I note that the previous 9.1.3 binaries used the newer libxml2.dll
though (same as the one in

So I'm guessing the Windows PostgreSQL binaries were built with the
old one, but packaged with the new one.

In response to


pgsql-bugs by date

Next:From: Edmund HornerDate: 2012-06-01 00:36:39
Subject: Re: 9.2 beta1 libxml2 can't be loaded on Windows
Previous:From: Adrian KlaverDate: 2012-05-31 23:45:32
Subject: Re: BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group