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

[Roumalyn T. <rt...@nt...>]

Hi!

Thank you for your reply. I just received a subscription confirmation.
I am re-sending my email.


I have installed a basic Postgres-QC cluster (1 GTM, 1C oordinator, and 2
datanodes) on a single machine.
I launched ./configure only in this machine.




On Fri, 16 Nov 2012 13:02:40 +0900, Michael Paquier
<mic...@gm...> wrote:
> 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