switching on libxml - Mailing list pgsql-admin

From Kasia Tuszynska
Subject switching on libxml
Date
Msg-id 232B5217AD58584C87019E8933556D11014695E34E@redmx2.esri.com
Whole thread Raw
In response to setting pg memory consumption on windows  (Kasia Tuszynska <ktuszynska@esri.com>)
Responses Re: switching on libxml
List pgsql-admin

Hello,

I am running Postgres 8.3.0 on RHEL 4, and trying to insert a value into an xml data type:

 

create table test_xml (name character varying(10), iteminfo xml)

insert into test_xml values ('bob', 'xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance')

 

I get the following error message:

 

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.

 

Is there a way to “switch on” the libxml option after a db cluster has been instantiated? Or do I really need to rebuild postgres with the --with-libxml parameter?

 

Thank you,

Sincerely,

Kasia

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: type cast from bytea to varchar or whatever
Next
From: Tom Lane
Date:
Subject: Re: switching on libxml