Message-ID: <4B9FC93A.1090209@gmail.com>
Date: Tue, 16 Mar 2010 12:08:58 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.8) Gecko/20100228 SUSE/3.0.3-1.1.1 Lightning/1.0b1
	Thunderbird/3.0.3
MIME-Version: 1.0
To: Richard Huxton <dev@archonet.com>
CC: pgsql-sql@postgresql.org
Subject: Re: installing uuid generators
References: <4B9EC98B.8080201@gmail.com> <4B9F4D6C.5040708@archonet.com>
In-Reply-To: <4B9F4D6C.5040708@archonet.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


On 03/16/2010 03:20 AM, Richard Huxton wrote:
> On 15/03/10 23:58, Rob Sargent wrote:
>> Stop me if you've heard this one before :)
>>
>> Given that pg_config --libdir yields "/usr/lib64"
>> to where/what would you expect
>>
>>    "AS '$libdir/uuid-ossp', 'uuid_generate_v5'"
>>
>> to resolve?
>>
>> The loader script,
>> ~/tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql,  generates
>> "tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql:9: ERROR:  could
>> not access file "$libdir/uuid-ossp": No such file or directory"
> 
> Could it be that $libdir doesn't contain uuid-ossp when the .sql script
> is being executed?
> 
> It's also worth checking that the pg_config you are executing is the one
> associated with postgresql-8.4.2 - make sure your PATH is set
> appropriately. I'm not sure that it would give this error, but I keep
> making the mistake of setting my PATH with the three versions I have on
> my dev box.
> 
Thanks for your suggestions.  You were exactly right.  I was pointed at
an 8.3 server in the hinterland, not my own.  Terribly sorry for the
noise. (Of course that fact was staring at me from the sql prompt, which
contains servername :/)

I'm still left worried about the correct procedure for getting uuid-oosp
installed properly on SUSE 11.  Does the server release's contrib
contain uuid-ossp?  I didn't see it on my desktop release.  (I don't
want to have to tell my mates to go through the issues I had building
the lib etc.)

Now I have to clean up after myself for having dropped links to that .so
everywhere!

Thanks again.