The following bug has been logged online:

Bug reference:      2301
Logged by:          Balázs Klein
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system:   WinXP
Description:        xml2 library not running on the Win Pg 8.1
Details: 

I have raised this issue in the pgsql.general newsgroup, Subject: installing
xml2 for pg 8.1 on winxp, but as I got no answers so far I am submitting
this as a bug.

There might be a problem with a missing extension in the pre-compiled 
windows version of Postgres 8.1 
It looks as though it's the 'MemoryContextSwitchTo' library which is 
present in 8.0 but missing from 8.1.

I was trying to install the xml2 library to Postgres as I found it on 
http://www.throwingbeans.org/postgresql_and_xml_updated.html but I had 
no luck. 

So I contacted Tom Dyson the author of the package and he informed me 
that there were others having a similar problem with the 8.1 compile 
while the library worked fine in the 8.0.3 version and he suggested that 
based on e-mails he got the problem might be the one I mentioned above. 

I just offered to report this problem of the build, unfortunately I 
can't help much more as this is far too high level for me.

After placing the downloaded dll's to their places, the actual error I get
is:

When I run

CREATE OR REPLACE FUNCTION xml_valid(text) RETURNS bool AS 
'libpgxml' LANGUAGE 'c' WITH (isStrict);

I got the error message 
ERROR:  could not load library "C:/Program 
Files/PostgreSQL/8.1/lib/libpgxml.dll": The specified procedure could 
not be found.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to