BUG #4914: uuid_generate_v4 not present in either source or yum/rpm - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4914
Logged by:          Dan Boeriu
Email address:      dan.boeriu@roost.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.