pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDebian Squeeze - no xml support for Pg 9.2
4+ messages / 3 participants
[nested] [flat]
* Debian Squeeze - no xml support for Pg 9.2
@ 2012-09-26 18:07 Volkmar Herbst <volkmar.herbst@gmx.de>
2012-10-02 07:43 ` Re: Debian Squeeze - no xml support for Pg 9.2 Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 1 reply; 4+ messages in thread
From: Volkmar Herbst @ 2012-09-26 18:07 UTC (permalink / raw)
To: 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.herbst@gmx.de> volkmar.herbst@gmx.de
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Debian Squeeze - no xml support for Pg 9.2
2012-09-26 18:07 Debian Squeeze - no xml support for Pg 9.2 Volkmar Herbst <volkmar.herbst@gmx.de>
@ 2012-10-02 07:43 ` Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 0 replies; 4+ messages in thread
From: Albe Laurenz @ 2012-10-02 07:43 UTC (permalink / raw)
To: Volkmar Herbst *EXTERN* <volkmar.herbst@gmx.de>; pgsql-admin
Volkmar Herbst wrote:
> 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?
That looks like the pg_config you called and the server you used are
not the ones that you built.
Is there a second PostgreSQL installation on the machine?
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
* Debian Squeeze - no xml support for Pg 9.2
@ 2012-09-26 18:11 Volkmar Herbst <volkmar.herbst@gmx.de>
2012-09-26 23:08 ` Re: Debian Squeeze - no xml support for Pg 9.2 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Volkmar Herbst @ 2012-09-26 18:11 UTC (permalink / raw)
To: 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.herbst@gmx.de> volkmar.herbst@gmx.de
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Debian Squeeze - no xml support for Pg 9.2
2012-09-26 18:11 Debian Squeeze - no xml support for Pg 9.2 Volkmar Herbst <volkmar.herbst@gmx.de>
@ 2012-09-26 23:08 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2012-09-26 23:08 UTC (permalink / raw)
To: Volkmar Herbst <volkmar.herbst@gmx.de>; +Cc: pgsql-admin
"Volkmar Herbst" <volkmar.herbst@gmx.de> writes:
> I rebuild with /usr/local/pgsql/postgresql-9.2.0/configure --with-libxml
> --with-python. Configuring make and make install went well.
OK ...
> However I get an error in postgres doing xml operations:
> select '<test></test>'::xml
> ERROR: unsupported XML feature
Then you're not actually using a postmaster with xml support in it;
most likely, you're still talking to the previous build. Did you
restart? Did you make sure to select the same install directory and
default port as before? (Debian's build of postgres is quite
nonstandard in these respects, so it seems likely that you'd need more
configure options than you mentioned in order to have a drop-in
replacement for a Debian build. But not being a user of Debian's
package I'm not the best person to ask for details.)
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-10-02 07:43 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-26 18:07 Debian Squeeze - no xml support for Pg 9.2 Volkmar Herbst <volkmar.herbst@gmx.de>
2012-10-02 07:43 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2012-09-26 18:11 Debian Squeeze - no xml support for Pg 9.2 Volkmar Herbst <volkmar.herbst@gmx.de>
2012-09-26 23:08 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox