Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGw16-00061S-8k for pgsql-admin@postgresql.org; Wed, 26 Sep 2012 18:07:24 +0000 Received: from mailout-de.gmx.net ([213.165.64.22]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TGw13-0007ax-Lu for pgsql-admin@postgresql.org; Wed, 26 Sep 2012 18:07:23 +0000 Received: (qmail invoked by alias); 26 Sep 2012 18:07:19 -0000 Received: from p5B27F1EE.dip.t-dialin.net (EHLO VHerbstNB) [91.39.241.238] by mail.gmx.net (mp020) with SMTP; 26 Sep 2012 20:07:19 +0200 X-Authenticated: #54096409 X-Provags-ID: V01U2FsdGVkX1/e9QI2Yl3eQdPHMCNM+cDPLemk9JqSSByAVCHuMh KsYorJxEhPNP8N From: "Volkmar Herbst" To: Subject: Debian Squeeze - no xml support for Pg 9.2 Date: Wed, 26 Sep 2012 20:07:19 +0200 Message-ID: <000701cd9c11$c620fc40$5262f4c0$@herbst@gmx.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0008_01CD9C22.89A9CC40" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac2cEcS8imUbVjU4ST2YFXDlOtXniA== Content-Language: de X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -0.9 (/) X-Archive-Number: 201210/2 X-Sequence-Number: 40118 This is a multi-part message in MIME format. ------=_NextPart_000_0008_01CD9C22.89A9CC40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3D-O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv configure: using CPPFLAGS=3D -D_GNU_SOURCE -I/usr/include/libxml2 configure: using LDFLAGS=3D -Wl,--as-needed =20 However I get an error in postgres doing xml operations: select ''::xml results in=20 =20 ERROR: unsupported XML feature LINE 1: select ''::xml ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. =20 ********** Error ********** =20 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 =20 Pg_config gives: =20 BINDIR =3D /usr/local/pgsql/bin DOCDIR =3D /usr/local/pgsql/share/doc HTMLDIR =3D /usr/local/pgsql/share/doc INCLUDEDIR =3D /usr/local/pgsql/include PKGINCLUDEDIR =3D /usr/local/pgsql/include INCLUDEDIR-SERVER =3D /usr/local/pgsql/include/server LIBDIR =3D /usr/local/pgsql/lib = PKGLIBDIR =3D /usr/local/pgsql/lib LOCALEDIR =3D /usr/local/pgsql/share/locale MANDIR = =3D /usr/local/pgsql/share/man SHAREDIR =3D /usr/local/pgsql/share = SYSCONFDIR =3D /usr/local/pgsql/etc PGXS =3D = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE =3D '-with-python' CC =3D gcc CPPFLAGS =3D -D_GNU_SOURCE CFLAGS =3D -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL =3D -fpic = LDFLAGS =3D -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags LDFLAGS_EX =3D LDFLAGS_SL =3D LIBS =3D -lpgport -lz -lreadline -lcrypt -ldl -lm VERSION =3D PostgreSQL = 9.2.0 =20 Could anybody help? =20 =20 Volkmar Herbst Leisniger Chaussee 10 04769 Sornzig Abla=DF =20 Tel.: 034362 30627 Mobil: 016098121740 Email: volkmar.herbst@gmx.de =20 ------=_NextPart_000_0008_01CD9C22.89A9CC40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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=A0 --with-python. Configuring make and make install went = well.

=

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

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

configure: using LDFLAGS=3D=A0 = -Wl,--as-needed

However I get an error in postgres doing xml = operations:

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

results in =

ERROR:=A0 unsupported XML feature

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

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = ^

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

HINT:=A0 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 =3D /usr/local/pgsql/bin

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

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

INCLUDEDIR =3D = /usr/local/pgsql/include

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

CONFIGURE =3D = '-with-python'

CC =3D gcc

CPPFLAGS =3D = -D_GNU_SOURCE

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

LDFLAGS_EX = =3D

LDFLAGS_SL =3D

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

Could anybody help?

Volkmar = Herbst

Leisniger = Chaussee 10

04769 = Sornzig Abla=DF

Tel.: 034362 = 30627

Mobil: = 016098121740

Email: volkmar.herbst@gmx.de

------=_NextPart_000_0008_01CD9C22.89A9CC40--