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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
xml.zip | application/octet-stream | 11.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-11-29 13:55:32 | Re: How do I get an OID from a record in table? |
Previous Message | Norberto Meijome | 2005-11-29 12:22:36 | Re: How do I get an OID from a record in table? |