From: | Chris spotts <rfusca(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, Devrim G?ND?Z <devrim(at)gunduz(dot)org> |
Subject: | Re: uuid-ossp |
Date: | 2009-04-04 19:16:14 |
Message-ID: | 1238872574.14191.8.camel@chris-laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2009-04-04 19:28:12 | Re: uuid-ossp |
Previous Message | Chris spotts | 2009-04-04 16:36:37 | Re: uuid-ossp |