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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
