switching on libxml

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: switching on libxml
Date: 2009-09-15 19:40:54
Message-ID: 232B5217AD58584C87019E8933556D11014695E34E@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-15 20:34:22 Re: switching on libxml
Previous Message Kevin Grittner 2009-09-15 16:52:56 Re: type cast from bytea to varchar or whatever