BUG #2751: contrib\pgxml.sql

Started by Dennisover 19 years ago2 messagesbugs
Jump to latest
#1Dennis
aiwa_azca@yahoo.com

The following bug has been logged online:

Bug reference: 2751
Logged by: Dennis
Email address: aiwa_azca@yahoo.com
PostgreSQL version: 8.1.5
Operating system: Gentoo 2006.1 server x86
Description: contrib\pgxml.sql
Details:

contrib\pgxml.sql has reference to xml_is_well_formed function. Now, libxml2
library under linux does not have support for this function and if I try to
add xml support to PG server under linux by running the SQL script in binary
distribution (say Windows) I get an error such as:

ERROR: could not find function "xml_is_well_formed" in file
"/usr/lib/postgresql/pgxml.so"
SQL state: 42883

However, the source code (postgresql-8.1.5.tar.bz2) has correct
contrib\pgxml.sql and does not reference "xml_is_well_formed" function. This
has caused me many hours of grief; to help other people,
"xml_is_well_formed" either needs to be removed or something else has to be
done.

Thank you.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dennis (#1)
Re: BUG #2751: contrib\pgxml.sql

"Dennis" <aiwa_azca@yahoo.com> writes:

PostgreSQL version: 8.1.5

contrib\pgxml.sql has reference to xml_is_well_formed function.

Not in 8.1 there isn't. Sounds like you are trying to use an 8.2 beta
sql script with an 8.1 library.

regards, tom lane