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

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

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=#

===



On Fri, 16 Nov 2012 16:22:06 +0900, Michael Paquier
<mic...@gm...> wrote:
> Knowing that you installed libxml2 on your machine, this should work
> correctly.
> Could you run those queries?
> CREATE TABLE xmltest (
>     id int,
>     data xml
> );
> 
> INSERT INTO xmltest VALUES (1, '<value>one</value>');
> INSERT INTO xmltest VALUES (2, '<value>two</value>');
> 
> On Fri, Nov 16, 2012 at 3:34 PM, Roumalyn Tiru <rt...@nt...>
> wrote:
> 
>> I found the following in my config.log
>>
>> ----
>>   $ ./configure --with-libxml
>>
>> configure:7478: gcc -o conftest -O2 -Wall -Wmissing-prototypes
>> -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
>> -Wformat-security -fno-strict-aliasing -fwrapv  -D_GNU_SOURCE
>> -I/usr/include/libxml2    conftest.c -lm   >&5
>> (Note: A lot of similar lines)
>> <...>
>>
>> configure:29757: using CPPFLAGS= -D_GNU_SOURCE -I/usr/include/libxml2
>>
>>
>> ## ---------------- ##
>> ## Cache variables. ##
>> ## ---------------- ##
>> ac_cv_header_libxml_parser_h=yes
>>
>> ## ----------------- ##
>> ## Output variables. ##
>> ## ----------------- ##
>> CPPFLAGS=' -D_GNU_SOURCE -I/usr/include/libxml2 '
>> configure_args=' '\''--with-libxml'\'''
>> with_libxml='yes'
>>
>> ## ----------- ##
>> ## confdefs.h. ##
>> ## ----------- ##
>> #define USE_LIBXML 1
>> #define HAVE_LIBXML2 1
>>
>> ----
>>
>> I am also using CentOS6.0 and libxml2.7.6
>>
>>
>>
>>
>> On Fri, 16 Nov 2012 15:06:06 +0900, Michael Paquier
>> <mic...@gm...> wrote:
>> > 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
>> >>
>>
>>
>>
------------------------------------------------------------------------------
>> 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
>>