On 31 May 2012 14:14, Edmund Horner <ejrh00@gmail.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. =A0However 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:
>
> =A01. Install binaries.
> =A02. Start server.
> =A03. Open psql session to postgres database.
> =A04. Run query: =A0SELECT xml '<foo>bar</foo>';
>
> Expected result: =A0query returns a single row like:
>
> =A0 =A0 =A0 =A0 =A0 xml
> =A0 =A0----------------
> =A0 =A0 <foo>bar</foo>
>
> Actual result:
>
> =A0 =A0postgres=3D# SELECT xml '<foo>bar</foo>';
> =A0 =A0ERROR: =A0could not set up XML error handler
> =A0 =A0LINE 1: select xml '<foo>bar</foo>';
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 ^
> =A0 =A0HINT: =A0This probably indicates that the version of libxml2 being
> used is not compatible with the
> =A0 =A0 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.