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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Morris, Roy
Sent: Wednesday, January 20, 2010 1:28 PM
To: Tom Lane
Cc: pgsql-novice@postgresql.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@sss.pgh.pa.us]
Sent: Wednesday, January 20, 2010 1:13 PM
To: Morris, Roy
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] UUID - 8.4.2

"Morris, Roy" <rmorris@internetsecure.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



--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice