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