Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml

*From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *John R Pierce
*Sent:* Thursday, June 12, 2014 10:34 AM
*To:* pgsql-general(at)postgresql(dot)org
*Subject:* Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL using
--with-libxml

On 6/12/2014 1:23 AM, Khangelani Gama wrote:

I then did the following:

1. We installed library 'xml2' (version >= 2.6.23)

2. ./configure --with-libxml

3. gmake

4. gmake install

was the previous version custom built with /no/ options ?
-I am not sure because it’s setup I was not involved in

what OS/distribution is this on?

- it’s running on CentOS release 6.4 (Final)

Another example:

c9900=# begin ;

BEGIN

c9900=# create table kmgtest (col1 xml);

CREATE TABLE

c9900=# insert into kmgtest values ('<one>something</one>');

ERROR: unsupported XML feature

LINE 1: insert into kmgtest values ('<one>something</one>');

^

DETAIL: This functionality requires the server to be built with libxml
support.

HINT: You need to rebuild PostgreSQL using --with-libxml.

--

john r pierce 37N 122W

somewhere on the middle of the left coast

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.