Обсуждение: 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

"Morris, Roy" <rmorris@internetsecure.com> writes:
> Thanks! I installed that now and ran the uuid sql script against my test
> db. It returned a few
> CREATE FUNCTION outputs.

Sounds about right.

> In psql I type uuid(); and it does not work?

The package doesn't appear to provide any function of that name ...
http://www.postgresql.org/docs/8.4/static/uuid-ossp.html

            regards, tom lane

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

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

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

Um ... why are you trying to do that?  uuid_in is built in as of 8.4.
It looks to me like you are trying to force the thing to take
definitions from an old version of contrib/uuid, and that's not gonna
work.

If you've got these definitions in an old dump file, just ignore the
errors on load.

            regards, tom lane