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: CAMyN-kC7i5z2aJK5VkafkyRNgMvnmZrA7bYB6Ch-_ATyijeHoQ@mail.gmail.com (view raw or flat)
Thread:
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
ftp://ftp.zlatkovic.com/libxml/oldreleases/libxml2-2.6.9.win32.zip
(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
ftp://ftp.zlatkovic.com/libxml/libxml2-2.7.8.win32.zip).

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

In response to

Responses

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-2014 The PostgreSQL Global Development Group