Re: uuid-ossp
От | Chris spotts |
---|---|
Тема | Re: uuid-ossp |
Дата | |
Msg-id | 1238862997.14191.6.camel@chris-laptop обсуждение исходный текст |
Ответ на | uuid-ossp (Chris spotts <rfusca@gmail.com>) |
Ответы |
Re: uuid-ossp
|
Список | pgsql-general |
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@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-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
В списке pgsql-general по дате отправления: