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

Dan Boeriu wrote:

> 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

> 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

This seems a packaging mistake, because the file is present in the build
tree, and after installing it the uuid_generate_v4 function is present.
Maybe you just need to install to postgresql-contrib package?  (But if
the uninstall script is there I guess you already have it)

alvherre=# \i /pgsql/install/84_rel/share/contrib/uuid-ossp.sql
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
alvherre=# \df *uuid*
                                       Listado de funciones
  Esquema   |       Nombre       | Tipo de dato de salida | Tipos de datos de argumentos |  Tipo
------------+--------------------+------------------------+------------------------------+--------
 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
 public     | uuid_generate_v1   | uuid                   |                              | normal
 public     | uuid_generate_v1mc | uuid                   |                              | normal
 public     | uuid_generate_v3   | uuid                   | namespace uuid, name text    | normal
 public     | uuid_generate_v4   | uuid                   |                              | normal
 public     | uuid_generate_v5   | uuid                   | namespace uuid, name text    | normal
 public     | uuid_nil           | uuid                   |                              | normal
 public     | uuid_ns_dns        | uuid                   |                              | normal
 public     | uuid_ns_oid        | uuid                   |                              | normal
 public     | uuid_ns_url        | uuid                   |                              | normal
 public     | uuid_ns_x500       | uuid                   |                              | normal
(22 filas)




--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support