<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 12, 2017 at 11:11 AM, Eli Mesika <span dir="ltr"><<a href="mailto:emesika@redhat.com" target="_blank">emesika@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-size:large">Hi</div><div style="font-size:large"><br></div><div style="font-size:large">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)<br></div><div style="font-size:large">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.</div><div style="font-size:large"><br></div><div style="font-size:large">1) make sure that the postgresql-contrib is installed on your machine (yum/dnf install postgresql-contrib -y)<br></div></div></blockquote><div><br><div style="font-family:arial,helvetica,sans-serif;display:inline" class="gmail_default">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<br></div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-size:large"></div><div style="font-size:large">2) run the following command from psql prompt while logging in with a DB admin (postgres) user <br></div><div style="font-size:large"> a) DROP FUNCTION IF EXISTS uuid_generate_v1();</div><div style="font-size:large"> b) CREATE EXTENSION "uuid-ossp";'</div><div style="font-size:large">3) validate from psql prompt by :</div><div style="font-size:large"><br></div><div style="font-size:large"># select * from pg_available_extensions where name = 'uuid-ossp' and installed_version IS NOT NULL;<br></div><div style="font-size:large"><br></div><div style="font-size:large">You should get the following result <br></div><div style="font-size:large"><br>-[ RECORD 1 ]-----+-----------------------<wbr>-------------------------<br>name | uuid-ossp<br>default_version | 1.0<br>installed_version | 1.0<br>comment | generate universally unique identifiers (UUIDs)<br></div><div style="font-size:large"><br></div><div style="font-size:large">Please contact me for any questions or problems you encounter after this patch is merged to master.<br></div><div style="font-size:large"><br></div><div style="font-size:large">[1] <a href="https://gerrit.ovirt.org/#/c/84832/" target="_blank">https://gerrit.ovirt.org/#/c/<wbr>84832/</a></div><div style="font-size:large"><br></div><div style="font-size:large"><br></div><div style="font-size:large">Thanks <br></div><span class="gmail-HOEnZb"><font color="#888888"><div style="font-size:large"><br></div><div style="font-size:large">Eli Mesika <br></div></font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><font size="1">Martin Perina<br>Associate Manager, Software Engineering<br>Red Hat Czech s.r.o.<br></font></div></div>
</div></div>