Skip site navigation (1) Skip section navigation (2)

Re: UUID - 8.4.2

From: "Morris, Roy" <rmorris(at)internetsecure(dot)com>
To: "Morris, Roy" <rmorris(at)internetsecure(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: UUID - 8.4.2
Date: 2010-01-20 19:47:03
Message-ID: 19BA112CA339EB47B0E90EBAE50D132D077E50E4@exch1.internal.priv (view raw or flat)
Thread:
Lists: pgsql-novice
Neat, this seems to be nothing but trouble huh? I think I am going to go
back and 
install from source ... we used to be able to create our own functions,
now we get
errors ... 

I checked of course that the files do exist and they are r_xr_xr_x


postgres=# CREATE FUNCTION
postgres-#     uuid_in(CSTRING) RETURNS uuid
postgres-#     STRICT
postgres-#     LANGUAGE C AS '/usr/lib/pgsql/uuid.so', 'pg_uuid_in';
ERROR:  could not access file "/usr/lib/pgsql/uuid.so": No such file or
directory



-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Morris, Roy
Sent: Wednesday, January 20, 2010 1:28 PM
To: Tom Lane
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] UUID - 8.4.2 

Thanks! I installed that now and ran the uuid sql script against my test
db. It returned a few
CREATE FUNCTION outputs. In psql I type uuid(); and it does not work?
Any thoughts?



-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Wednesday, January 20, 2010 1:13 PM
To: Morris, Roy
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] UUID - 8.4.2 

"Morris, Roy" <rmorris(at)internetsecure(dot)com> writes:
> I have installed 8.4 from a package on Linux FC12. I am wondering if
> there is any way to install UUID functions
> without building Postgres from source?

They're in the postgresql-contrib package ...

			regards, tom lane



Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-01-20 21:34:17
Subject: Re: UUID - 8.4.2
Previous:From: Magnus HaganderDate: 2010-01-20 19:27:04
Subject: Re: [NOVICE] Python verison for build in config.pl (Win32)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group