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.
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 |