BUG #2301: xml2 library not running on the Win Pg 8.1
The following bug has been logged online:
Bug reference: 2301
Logged by: Balázs Klein
Email address: Balazs.Klein@axelero.hu
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.
Balázs Klein wrote:
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.
You did get at least one answer as far as I remember.
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.
Did you recompile pgxml against 8.1, or are you trying to use DLLs that
were compiled against 8.0? The latter won't work. You need to either
produce yourself or convince someone else to provide you with a DLL that
was compiled against 8.1.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
On 5/3/06 17:38, "Alvaro Herrera" <alvherre@commandprompt.com> wrote:
Balázs Klein wrote:
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.You did get at least one answer as far as I remember.
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.Did you recompile pgxml against 8.1, or are you trying to use DLLs that
were compiled against 8.0? The latter won't work. You need to either
produce yourself or convince someone else to provide you with a DLL that
was compiled against 8.1.
xml2 has never been ported to Win32, mainly because it's a non-default
module (ie. Not included in the /contrib makefile) which requires additional
libraries. It's on my list to look at, but I've not got to it yet.
Regards, Dave.
Added to TODO:
o Port contrib/xml2
---------------------------------------------------------------------------
Dave Page wrote:
On 5/3/06 17:38, "Alvaro Herrera" <alvherre@commandprompt.com> wrote:
Bal??zs Klein wrote:
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.You did get at least one answer as far as I remember.
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.Did you recompile pgxml against 8.1, or are you trying to use DLLs that
were compiled against 8.0? The latter won't work. You need to either
produce yourself or convince someone else to provide you with a DLL that
was compiled against 8.1.xml2 has never been ported to Win32, mainly because it's a non-default
module (ie. Not included in the /contrib makefile) which requires additional
libraries. It's on my list to look at, but I've not got to it yet.Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +
Dear Alvaro,
no, I didn't get a reply on pgsql.general - I am not complaining about it
just wanted to pass the info to a place where it might be useful and explain
why I am cross-posting.
I didn't compile anything just downloaded the 8.1 Win binaries from
http://www.postgresql.org/ftp/binary/v8.1.3/win32/
and the binaries from
www.throwingbeans.org/pg801_windows_xml.zip
they didn't work together, so I posted first to Tom Dyson
thomasdyson@gmail.com and he said the problem is with the pg compile so I
posted here as well in the hope that in a future version they may work
together.
Thanks for your reply.
Balázs
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
Sent: 2006. március 5. 18:39
To: Balázs Klein
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #2301: xml2 library not running on the Win Pg 8.1
Balázs Klein wrote:
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.
You did get at least one answer as far as I remember.
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.
Did you recompile pgxml against 8.1, or are you trying to use DLLs that
were compiled against 8.0? The latter won't work. You need to either
produce yourself or convince someone else to provide you with a DLL that
was compiled against 8.1.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.