glitch installing xml support in 9.1.beta2

On Fri, 2011-06-24 at 11:22 -0600, Rob Sargent wrote:

OpenSuse 11.4 x86-64

gmake install builds and places the requisite pieces as expected.

Running
psql --username postgres -d postgres -f xml2--1.0,sql
results in
psql:xml2--1.0.sql:8: ERROR: function "xml_valid" already
exists with same argument types
psql:xml2--1.0.sql:12: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:16: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:20: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:24: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:28: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:34: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
(This from second run, so xml_valid worked the first time).

I see that the xml2.control file defines module_pathname =
'$libdir/pgxml', but how is that passed to the psql run? Or am I to
manually update the sql scripts?
.

You don't use it explicitely. You use "CREATE EXTENSION", and it will
use it.

psql --username postgres -d postgres -c "CREATE EXTENSION xml2"

and it should work. That's one of the great things in 9.1.

Here's my configuration of the main build
./configure --with-libraries=/usr/local/lib --with-python
--with-openssl --with-ldap --with-ossp-uuid --with-libxml
--with-libxslt --enable-debug --prefix=/opt/PostgreSQL/9.1

Haven't gone into uuid stuff yet...

Cheers,

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

Guillaume Lelarge wrote:

On Fri, 2011-06-24 at 11:22 -0600, Rob Sargent wrote:

OpenSuse 11.4 x86-64

gmake install builds and places the requisite pieces as expected.

Running
psql --username postgres -d postgres -f xml2--1.0,sql
results in
psql:xml2--1.0.sql:8: ERROR: function "xml_valid" already
exists with same argument types
psql:xml2--1.0.sql:12: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:16: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:20: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:24: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:28: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:34: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
(This from second run, so xml_valid worked the first time).

I see that the xml2.control file defines module_pathname =
'$libdir/pgxml', but how is that passed to the psql run? Or am I to
manually update the sql scripts?
.

You don't use it explicitely. You use "CREATE EXTENSION", and it will
use it.

psql --username postgres -d postgres -c "CREATE EXTENSION xml2"

and it should work. That's one of the great things in 9.1.

Very cool. Obviously I missed a release note or two.

Thanks

On 06/25/2011 01:10 AM, Guillaume Lelarge wrote:

On Fri, 2011-06-24 at 11:22 -0600, Rob Sargent wrote:

OpenSuse 11.4 x86-64

gmake install builds and places the requisite pieces as expected.

Running
psql --username postgres -d postgres -f xml2--1.0,sql
results in
psql:xml2--1.0.sql:8: ERROR: function "xml_valid" already
exists with same argument types
psql:xml2--1.0.sql:12: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:16: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:20: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:24: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:28: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
psql:xml2--1.0.sql:34: ERROR: could not access file
"MODULE_PATHNAME": No such file or directory
(This from second run, so xml_valid worked the first time).

I see that the xml2.control file defines module_pathname =
'$libdir/pgxml', but how is that passed to the psql run? Or am I to
manually update the sql scripts?
.

You don't use it explicitely. You use "CREATE EXTENSION", and it will
use it.

psql --username postgres -d postgres -c "CREATE EXTENSION xml2"

and it should work. That's one of the great things in 9.1.

Worked perfectly for xml2 thanks.

As for uuid I had to run the extendor like this:
psql --username=postgres -d postgres -c 'create extension "uuid-ossp"'

Unfortunate hyphenation in the name of the module.