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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
