On Tue, Dec 12, 2017 at 11:11 AM, Eli Mesika <emesika(a)redhat.com> wrote:
Hi
We had decided to drop our UUID generation function from DB in 4.2.1 and
use the one provided by PG (using an extension)
Please note that once this patch [1] is merged , you will have to do the
following steps in your env in order that it will continue working.
1) make sure that the postgresql-contrib is installed on your machine
(yum/dnf install postgresql-contrib -y)
Just adding that package name is "postgresql-contrib" for Fedora and
"rh-postgresql95-postgresql-contrib" for CentOS and it needs to be
installed manually on engine developer's machines
2) run the following command from psql prompt while logging in with a
DB
admin (postgres) user
a) DROP FUNCTION IF EXISTS uuid_generate_v1();
b) CREATE EXTENSION "uuid-ossp";'
3) validate from psql prompt by :
# select * from pg_available_extensions where name = 'uuid-ossp' and
installed_version IS NOT NULL;
You should get the following result
-[ RECORD 1 ]-----+------------------------------------------------
name | uuid-ossp
default_version | 1.0
installed_version | 1.0
comment | generate universally unique identifiers (UUIDs)
Please contact me for any questions or problems you encounter after this
patch is merged to master.
[1]
https://gerrit.ovirt.org/#/c/84832/
Thanks
Eli Mesika
--
Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.