PostgreSQL's build in XML data type does not work in Alpine
PostgreSQL has build
in support
for XML data type but it does not work in Alpine’s package (trying
on 9.5.2-r0
version).
Inserting into table with XML column leads to
ERROR: unsupported XML feature
:
> CREATE TABLE test (node xml);
> INSERT INTO test (node) VALUES ('<a>xml node</a>');
ERROR: unsupported XML feature
LINE 1: INSERT INTO test (node) VALUES ('<a>xml node</a>');
^
DETAIL: This functionality requires the server to be built with libxml support.
HINT: You need to rebuild PostgreSQL using --with-libxml.
The reason is Alpine’s PostgreSQL binary is not compiled with
--with-libxml
option.
I tried to run ./configure
with --with-libxml
option from
here
and it compiles without errors.
Can you please enable this --with-libxml
option by default so
PostgreSQL’s XML data type would work for everybody?
(from redmine: issue id 5383, created on 2016-04-08, closed on 2016-05-26)
- Changesets:
- Revision 5b54456c by Natanael Copa on 2016-04-08T11:32:24Z:
main/postgresql: build with libxml support
fixes #5383
- Revision 3eba6aaf by Natanael Copa on 2016-04-08T12:16:13Z:
main/postresql: remove duplicate libxml2-dev
ref #5383