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.