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

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

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

> 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.
>
That's honestly strange.
Here is the libxml command I use and it works.
configure --prefix=$PSQL_INSTALL_FOLDER --with-libxml

What is the output of config.log after launching configure and by searching
on a keyword like "libxml"?


>
>
>
>
> 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
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
Michael Paquier
http://michael.otacoo.com