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