<div dir="ltr">Can you please update us on this thread once the patch is actually merged?<div><br></div><div>Thanks,</div><div>Oved</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 12, 2017 at 12:53 PM, Martin Perina <span dir="ltr"><<a href="mailto:mperina@redhat.com" target="_blank">mperina@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-family:arial,helvetica,sans-serif"><br></div><div class="gmail_extra"><br><div class="gmail_quote"><span class="">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></span><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-<wbr>contrib" for CentOS and it needs to be installed manually on engine developer's machines<br></div> </div><span class=""><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/8<wbr>4832/</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="m_-7791137237060041711gmail-HOEnZb"><font color="#888888"><div style="font-size:large"><br></div><div style="font-size:large">Eli Mesika <br></div></font></span></div>
</blockquote></span></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><br>-- <br><div class="m_-7791137237060041711gmail_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>
</font></span></div></div>
</blockquote></div><br></div>