On Fri, Nov 16, 2012 at 10:36 AM, Roumalyn Tiru <rt...@nt...>wrote:
> Hi All,
>
> I am performing a functionality test of Postgres-XC.
> For XML data type, I am able to create a table with xml type but when I
> try to insert values, the following error message is displayed.
>
>
> ERROR: unsupported XML feature
> DETAIL: This functionality requires the server to be built with libxml
> support.
> HINT: You need to rebuild PostgreSQL using --with-libxml.
>
>
> I have configured and installed Postgres-XC with --with-libxml option.
>
Have you launched ./configure with option --with-libxml on ALL the nodes
where binaries are installed if you use multiple servers?
I use xml libs myself and I got:
postgres=# CREATE TABLE xmltest (
postgres(# id int,
postgres(# data xml
postgres(# );
CREATE TABLE
postgres=#
postgres=# INSERT INTO xmltest VALUES (1, '<value>one</value>');
INSERT 0 1
postgres=# INSERT INTO xmltest VALUES (2, '<value>two</value>');
INSERT 0 1
--
Michael Paquier
http://michael.otacoo.com
|
