<div dir="ltr"><div class="gmail_default" style="font-size:large">Hi Guys <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Please note that this patch was merged .</div><div class="gmail_default" style="font-size:large">You should follow all steps described in the original email <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">If you have any questions or problems, please contact me <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Eli<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 12, 2017 at 12:11 PM, 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-size:large">Hi</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" 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 class="gmail_default" 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 class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" 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 class="gmail_default" style="font-size:large">2) run the following command from psql prompt while logging in with a DB admin (postgres) user <br></div><div class="gmail_default" style="font-size:large"> a) DROP FUNCTION IF EXISTS uuid_generate_v1();</div><div class="gmail_default" style="font-size:large"> b) CREATE EXTENSION "uuid-ossp";'</div><div class="gmail_default" style="font-size:large">3) validate from psql prompt by :</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"># select * from pg_available_extensions where name = 'uuid-ossp' and installed_version IS NOT NULL;<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">You should get the following result <br></div><div class="gmail_default" 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 class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Please contact me for any questions or problems you encounter after this patch is merged to master.<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" 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 class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Thanks <br></div><span class="HOEnZb"><font color="#888888"><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Eli Mesika <br></div></font></span></div>
</blockquote></div><br></div>