Re: [Postgres-xc-general] Question about XML support in Postgres-XC

[Michael P. <mic...@gm...>]

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