Re: UUID - 8.4.2

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