Skip site navigation (1) Skip section navigation (2)

Debian Squeeze - no xml support for Pg 9.2

From: "Volkmar Herbst" <volkmar(dot)herbst(at)gmx(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Debian Squeeze - no xml support for Pg 9.2
Date: 2012-09-26 18:07:19
Message-ID: 000701cd9c11$c620fc40$5262f4c0$@herbst@gmx.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all,

I have a problem with xml support on a fresh installation of pg 9.2. I
configures and build postgres with xml.

I rebuild with /usr/local/pgsql/postgresql-9.2.0/configure --with-libxml
--with-python. Configuring make and make install went well.

configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv

configure: using CPPFLAGS= -D_GNU_SOURCE -I/usr/include/libxml2

configure: using LDFLAGS=  -Wl,--as-needed

 

However I get an error in postgres doing xml operations:

select '<test></test>'::xml

results in 

 

ERROR:  unsupported XML feature

LINE 1: select '<test></test>'::xml

               ^

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

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

 

********** Error **********

 

ERROR: unsupported XML feature

SQL state: 0A000

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

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

Character: 8

 

Pg_config gives:

 

BINDIR = /usr/local/pgsql/bin

DOCDIR = /usr/local/pgsql/share/doc

HTMLDIR = /usr/local/pgsql/share/doc

INCLUDEDIR = /usr/local/pgsql/include

PKGINCLUDEDIR = /usr/local/pgsql/include INCLUDEDIR-SERVER =
/usr/local/pgsql/include/server LIBDIR = /usr/local/pgsql/lib PKGLIBDIR =
/usr/local/pgsql/lib LOCALEDIR = /usr/local/pgsql/share/locale MANDIR =
/usr/local/pgsql/share/man SHAREDIR = /usr/local/pgsql/share SYSCONFDIR =
/usr/local/pgsql/etc PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk

CONFIGURE = '-with-python'

CC = gcc

CPPFLAGS = -D_GNU_SOURCE

CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL = -fpic LDFLAGS =
-Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags

LDFLAGS_EX =

LDFLAGS_SL =

LIBS = -lpgport -lz -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 9.2.0

 

Could anybody help?

 

 

Volkmar Herbst

Leisniger Chaussee 10

04769 Sornzig AblaƟ

 

Tel.: 034362 30627

Mobil: 016098121740

Email:  <mailto:volkmar(dot)herbst(at)gmx(dot)de> volkmar(dot)herbst(at)gmx(dot)de

 

Responses

pgsql-admin by date

Next:From: Volkmar HerbstDate: 2012-09-26 18:11:21
Subject: Debian Squeeze - no xml support for Pg 9.2
Previous:From: Rick DicaireDate: 2012-09-26 11:35:13
Subject: Re: WAL recovery failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group