Search Postgresql Archives

Re: uuid-ossp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Well, the only file that shows up is the uninstall file? Thats a little
odd.
Looks like I'll be rebuilding from source on monday...joyous.
On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
> Chris spotts <rfusca@xxxxxxxxx> 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-server andRP
> > 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux