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

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

On Fri, Nov 16, 2012 at 4:25 PM, Roumalyn Tiru <rt...@nt...> wrote:

> Below is the output:
>
> ===
> postgres=# CREATE TABLE xmltest (
> postgres(#     id int,
> postgres(#     data xml
> postgres(# );
> CREATE TABLE
> postgres=# INSERT INTO xmltest VALUES (1, '<value>one</value>');
> ERROR:  unsupported XML feature
> LINE 1: INSERT INTO xmltest VALUES (1, '<value>one</value>');
>                                        ^
> DETAIL:  This functionality requires the server to be built with libxml
> support.
> HINT:  You need to rebuild PostgreSQL using --with-libxml.
> postgres=# INSERT INTO xmltest VALUES (2, '<value>two</value>');
> ERROR:  unsupported XML feature
> LINE 1: INSERT INTO xmltest VALUES (2, '<value>two</value>');
>                                        ^
> DETAIL:  This functionality requires the server to be built with libxml
> support.
> HINT:  You need to rebuild PostgreSQL using --with-libxml.
> postgres=#
>
The error message is clear, the binary "postgres" you are using to launch
your nodes has not been compiled with libxml.
You would get the same error with vanilla postgres.
-- 
Michael Paquier
http://michael.otacoo.com