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

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

Hi!

Sorry for the confusion. This is still related to the problem I posted
about the XML data type.

Previously, I started the servers using pg_ctl commands:
gtm_ctl -Z gtm -D /usr/local/pgsql/data_gtm start
pg_ctl start -D /usr/local/pgsql/data_datanode1 -Z datanode
pg_ctl start -D /usr/local/pgsql/data_datanode2 -Z datanode
pg_ctl start -D /usr/local/pgsql/data_coordinator1 -Z coordinator

Then, I execute INSERT statements for a table with XML data type:
CREATE TABLE test (y int, x xml);
INSERT INTO test VALUES (1, '<foo>abc</foo>');

Then, I get the error:
ERROR:  unsupported XML feature

When I read this message, I tried to change the way I started the servers:
>>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.

I used postgres directly to start the servers.
/usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm 1>&1 &
/usr/local/pgsql/bin/postgres -X -p 15432 -D
/usr/local/pgsql/data_datanode1 1>&1 &
/usr/local/pgsql/bin/postgres -X -p 15433 -D
/usr/local/pgsql/data_datanode2 1>&1 &
/usr/local/pgsql/bin/postgres -C -D /usr/local/pgsql/data_coordinator1
1>&1 &

When I executed the INSERT statement again, it was successful.

Does using pg_ctl instead of postgres have any limitation?

Thank you!



On Mon, 19 Nov 2012 13:19:56 +0900, Michael Paquier
<mic...@gm...> wrote:
> On Mon, Nov 19, 2012 at 1:10 PM, Roumalyn Tiru <rt...@nt...>
> wrote:
> 
>> I have noticed the following:
>> When I start the servers using pg_ctl, I get the error.
>> But when I use postgres, the error does not occur.
>> For example:
>> /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm 1>&1 &
>> /usr/local/pgsql/bin/postgres -X -p 15432 -D
>> /usr/local/pgsql/data_datanode1 1>&1 &
>> /usr/local/pgsql/bin/postgres -X -p 15433 -D
>> /usr/local/pgsql/data_datanode2 1>&1 &
>> /usr/local/pgsql/bin/postgres -C -D /usr/local/pgsql/data_coordinator1
>> 1>&1 &
>>
>> Do you have any idea why this happens?
>>
> Sorry I do not understand your problem.
> What is the error message you are seeing and when (at which command)
does
> it occur?