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

On Fri, Jun 1, 2012 at 1:39 AM, Edmund Horner <ejrh00(at)gmail(dot)com> wrote:
> On 1 June 2012 12:36, Edmund Horner <ejrh00(at)gmail(dot)com> wrote:
>> On 1 June 2012 12:14, Edmund Horner <ejrh00(at)gmail(dot)com> wrote:
>>> 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.
>>
>>
>> Also, if libxml2.dll is replaced with the 2.6 version as above,
>> "CREATE EXTENSION xml2" will result in this:
>>
>>    ERROR:  could not load library "C:/ehorner/pgsql/lib/pgxml.dll":
>> The specified procedure could not be found.
>>
>> Which may imply that that DLL was built with the 2.7 version.  With
>> the 2.7 version in place as originally packaged, we have can load the
>> extension but not use the functions from it.
>>
>>    postgres=# create extension xml2;
>>    CREATE EXTENSION
>>
>>    postgres=# select xslt_process('<foo/>', '<bar/>');
>>    ERROR:  could not set up XML error handler
>>    HINT:  This probably indicates that the version of libxml2 being
>> used is not compatible with the
>>     libxml2 header files that PostgreSQL was built with.
>>
>> I wanted to check whether the packaged libxslt.dll had the same
>> compatibility situation as libxml2.dll does.  Unfortunately it seems
>> doing so means using both versions of the library at once!
>>
>> Edmund.
>
> Argh, I forget to mention the packaged pgadmin3.exe (in the same bin
> dir as postgres) wants the 2.7 version of the DLL (as packaged).

Hi

Please test 9.2 beta 2 - that's the first build to come from the new
build machine that'll be used for this release. It's got a new set of
dependencies which should all work correctly.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company