BUG #4914: uuid_generate_v4 not present in either source or yum/rpm

From: "Dan Boeriu" <dan(dot)boeriu(at)roost(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4914: uuid_generate_v4 not present in either source or yum/rpm
Date: 2009-07-09 23:21:31
Message-ID: 200907092321.n69NLVuj065350@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4914
Logged by: Dan Boeriu
Email address: dan(dot)boeriu(at)roost(dot)com
PostgreSQL version: 8.4
Operating system: Red Hat 5.3
Description: uuid_generate_v4 not present in either source or yum/rpm
Details:

I tried several times to build Postgres 8.4 with the ossp uuid both from
source and from yum/rpm.
I do have installed on the server uuid 1.6
The only functions I have in 8.4 are:
roost=# \df *uuid*
List of functions
Schema | Name | Result data type | Argument data types | Type
------------+-----------+------------------+---------------------+--------
pg_catalog | uuid_cmp | integer | uuid, uuid | normal
pg_catalog | uuid_eq | boolean | uuid, uuid | normal
pg_catalog | uuid_ge | boolean | uuid, uuid | normal
pg_catalog | uuid_gt | boolean | uuid, uuid | normal
pg_catalog | uuid_hash | integer | uuid | normal
pg_catalog | uuid_in | uuid | cstring | normal
pg_catalog | uuid_le | boolean | uuid, uuid | normal
pg_catalog | uuid_lt | boolean | uuid, uuid | normal
pg_catalog | uuid_ne | boolean | uuid, uuid | normal
pg_catalog | uuid_out | cstring | uuid | normal
pg_catalog | uuid_recv | uuid | internal | normal
pg_catalog | uuid_send | bytea | uuid | normal
(12 rows)

What I used to have is:
roost=# \df *uuid*
List of functions
Schema | Name | Result data type | Argument data types

------------+--------------------+------------------+-----------------------
----
pg_catalog | uuid_cmp | integer | uuid, uuid
pg_catalog | uuid_eq | boolean | uuid, uuid
pg_catalog | uuid_ge | boolean | uuid, uuid
pg_catalog | uuid_gt | boolean | uuid, uuid
pg_catalog | uuid_hash | integer | uuid
pg_catalog | uuid_le | boolean | uuid, uuid
pg_catalog | uuid_lt | boolean | uuid, uuid
pg_catalog | uuid_ne | boolean | uuid, uuid
pg_catalog | uuid_recv | uuid | internal
pg_catalog | uuid_send | bytea | uuid
public | uuid_generate_v1 | uuid |
public | uuid_generate_v1mc | uuid |
public | uuid_generate_v3 | uuid | namespace uuid, name
text
public | uuid_generate_v4 | uuid |
public | uuid_generate_v5 | uuid | namespace uuid, name
text
public | uuid_nil | uuid |
public | uuid_ns_dns | uuid |
public | uuid_ns_oid | uuid |
public | uuid_ns_url | uuid |
public | uuid_ns_x500 | uuid |
(20 rows)

Now in 8.3.7 I installed a uuid package from postgres yum and run a script:
/usr/share/pgsql/contrib/uuid-ossp.sql
which I cannot find anymore in 8.4.
The uninstall script though is present in both 8.3.7 and 8.4:
/usr/share/pgsql/contrib/uninstall_uuid-ossp.sql

How could I get the uuid_generate_vX functions in Postgres 8.4?

Thanks a bunch,
Dan Boeriu.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2009-07-09 23:21:53 Re: BUG #4913: Row missing from primary key index
Previous Message Tom Lane 2009-07-09 23:13:36 Re: BUG #4913: Row missing from primary key index