Re: uuid-ossp

FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3

I'm planning on rolling my own from source as well.

Dave Kerr

Chris spotts wrote:
> Thanks, I got it installed from source and  got uuid-ossp working.   One
> of the easier installs from source for a major app that I've done.
> Appreciate the help.
>
> Chris
> On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
>> Chris spotts <rfusca@gmail.com> writes:
>>> I’m brand new to Postgresql and working on moving an
>>> existing large DB into it.  I’m trying to get uuid-ossp
>>> functions to work.  I know the UUID type is installed, but I need the
>>> generate functions.  I’ve installed postgresql-se
>> rver and
>>> postgresql-contrib from the postgresql yum repos (working with Oracle
>>> Unbreakable Linux – which is TERRIBLE, but I
>>> don’t have a choice in the matter) and everything is good.
>>> I just cannot for the life of me figure out how to install the
>>> uuid-ossp functions.  I’ve seen stuff about a .sql query to
>>> run, but I’ve done an updatedb/locate and cannot find it.
>>> It is not in the contrib folder.  Any help would be much appreciated.
>> Well, if Oracle haven't managed to totally break the rpm infrastructure,
>> then "rpm -ql postgresql-contrib" should give you a list of all the
>> files installed by that rpm.  On my machine grepping that for uuid shows
>>
>> /usr/lib64/pgsql/uuid-ossp.so
>> /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
>> /usr/share/pgsql/contrib/uuid-ossp.sql
>>
>> (obviously it might be lib not lib64 if not a 64-bit install).  The
>> third of these is the SQL script you need to run to install the
>> functions in a particular database.
>>
>> It's possible that the PGDG RPMs don't build uuid support, in which case
>> you won't see those files.  In that case the answer would be to nag
>> Devrim about including it, or rebuild from the SRPMs for yourself ...
>>
>>             regards, tom lane
>
>