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

Re: PGXML support for postgreSQL on Windows

From: George Weaver <gweaver(at)shaw(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Cc: t(dot)b(dot)rijpma(at)student(dot)tudelft(dot)nl
Subject: Re: PGXML support for postgreSQL on Windows
Date: 2005-11-29 13:30:43
Message-ID: 006c01c5f4e9$1b7532b0$6400a8c0@Dell4500 (view raw or flat)
Thread:
Lists: pgsql-novice
----- Original Message ----- 
From: "T j i b b e"

> XML2 is not included in the windows postgresql installer. So I googled and 
> downloaded a windows binary from http://www.u-moe.org/pgxml/.
>
> I tried to install it:
>
> C:\Program Files\PostgreSQL\8.1\bin>psql -U postgres -f 
> ..\share\contrib\pgxml.sql
>
> And get this error:
>
> psql:../share/contrib/pgxml.sql:4: ERROR:  could not load library 
> "C:/Program Files/PostgreSQL/8.1/lib/pgxml.dll": The specified procedure 
> could not be found.

Hi Tjibbe,

The xml2 package from http://www.u-moe.org/pgxml/ does not include 
libxslt.dll which is necessary to install xml2 on postgres 8.1.  You can get 
the required dll's directly from http://ftp.zlatkovic.com/pub/libxml/ - you 
need libxml2.dll, libxslt.dll and iconv.dll.

I think you will find as well that pgxml.dll from 
http://www.u-moe.org/pgxml/ will not work with 8.1.  I have attached a zip 
copy of pgxml.dll which I compiled from source for 8.1 which should work.

With pgxml.dll in C:/Program Files/PostgreSQL/8.1/lib/ and libxml2.dll, 
libxslt.dll and iconv.dll in C:/Program Files/PostgreSQL/8.1/bin/, you
should be able to install the xml2 functions.  You may have to add 
C:/Program Files/PostgreSQL/8.1/lib to your system path (and then reboot), 
to get the install to work.  I had to do this on a laptop running XP Pro.

If you still encounter problems, I would suggest compiling pgxml.dll from 
source.  I am running XP rather than Windows 2000.

Regards,
George

Attachment: xml.zip
Description: application/octet-stream (11.6 KB)

In response to

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2005-11-29 13:55:32
Subject: Re: How do I get an OID from a record in table?
Previous:From: Norberto MeijomeDate: 2005-11-29 12:22:36
Subject: Re: How do I get an OID from a record in table?

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