<html><head></head><body><div style="color:#000; background-color:#fff; font-family:標楷體, dfkai-sb;font-size:16px"><div id="yui_3_16_0_ym19_1_1518659984271_11067"><span>Hi Bogdan,</span></div><div id="yui_3_16_0_ym19_1_1518659984271_11290"><span><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1518659984271_11291"><span id="yui_3_16_0_ym19_1_1518659984271_11230"><tt id="yui_3_16_0_ym19_1_1518659984271_11231">Thanks for the reply. I'll see if I can use </tt></span><tt id="yui_3_16_0_ym19_1_1518659984271_11232">call-Id + from_tag</tt><span></span> for it. But at the moment we are using uuid version 1 for this to make sure we get more accurate uniqueness. <br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1518659984271_11292"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1518659984271_11293"><br></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: 標楷體, dfkai-sb; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Wednesday, 14 February 2018, 15:54, Bogdan-Andrei Iancu <bogdan@opensips.org> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div id="yiv7288260675"><div>
<tt>Hi,<br clear="none">
<br clear="none">
OK, the uuid is custom data type (specific to postgres ??), so
doing the cast at DB level is the proper way to address the
warning.<br clear="none">
<br clear="none">
But, why not using the call-Id + from_tag as uuid for the calls ?<br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv7288260675moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-freetext" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-freetext" target="_blank" href="http://www.opensips.org/events/Summit-2018Amsterdam">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre>
<div class="yiv7288260675yqt1134081869" id="yiv7288260675yqt29559"><div class="yiv7288260675moz-cite-prefix">On 02/14/2018 12:03 PM, Pasan Meemaduma
wrote:<br clear="none">
</div>
<blockquote type="cite">
<div style="color:#000;background-color:#fff;font-family:標楷體, dfkai-sb;font-size:16px;">
<div id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27640">Hi Bogdan,</div>
<div id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27685"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27745">It
returns the postgres data type uuid. I put that in acc extra
field to keep track calls. <br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27686"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27776">If I
use following, I'm not getting the warning anymore. <br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27794"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27804">avp_db_query("SELECT
uuid_generate_v1mc()::varchar","$avp(callid)")</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27805"><br clear="none">
</div>
<div id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_27635"><span></span></div>
<div class="yiv7288260675qtdSeparateBR"><br clear="none">
<br clear="none">
</div>
<div class="yiv7288260675yahoo_quoted" style="display:block;">
<div style="font-family:標楷體, dfkai-sb;font-size:16px;">
<div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif;font-size:16px;">
<div dir="ltr"><font size="2" face="Arial"> On Wednesday,
14 February 2018, 14:55, Bogdan-Andrei Iancu
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-rfc2396E" ymailto="mailto:bogdan@opensips.org" target="_blank" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a> wrote:<br clear="none">
</font></div>
<br clear="none">
<br clear="none">
<div class="yiv7288260675y_msg_container">
<div id="yiv7288260675">
<div> <tt>Hi Pasan,<br clear="none">
<br clear="none">
But from the DB point of view, what data type does
your procedure return ?<br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv7288260675moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-freetext" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-freetext" target="_blank" href="http://www.opensips.org/events/Summit-2018Amsterdam">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre>
<div class="yiv7288260675yqt6330490175" id="yiv7288260675yqt58037">
<div class="yiv7288260675moz-cite-prefix">On
02/14/2018 08:51 AM, Pasan Meemaduma via Users
wrote:<br clear="none">
</div>
<blockquote type="cite">
<div style="color:#000;background-color:#fff;font-family:標楷體, dfkai-sb;font-size:16px;">
<div id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3344">Hi
List,<br clear="none">
</div>
<div id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3333"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3332">I
got another issue where opensips issue a
warning I'm trying to load a uuid from a
postgres database as opensips doesn't have a
built-in function to generate a uuid. How do
I get rid of this warning ?</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3331"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3334"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3330">WARNING:db_postgres:db_postgres_get_columns:
unhandled data type column
(uuid_generate_v1mc) type id (2950), use
DB_STRING as default<br id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3288" clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3335"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3329">Its
caused by following line in my config</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3328"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_5015">avp_db_query("SELECT
uuid_generate_v1mc()","$avp(callid)");</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3327"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3326"><br clear="none">
</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_3218">does
this mean I need to convert it to string
before returning from postgres via the sql I
use ?</div>
<div dir="ltr" id="yiv7288260675yui_3_16_0_ym19_1_1518589825317_5033"><br clear="none">
</div>
</div>
<br clear="none">
<fieldset class="yiv7288260675mimeAttachmentHeader"></fieldset>
<br clear="none">
<pre>_______________________________________________
Users mailing list
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-abbreviated" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a rel="nofollow" shape="rect" class="yiv7288260675moz-txt-link-freetext" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
<br clear="none">
</div>
</div>
<br clear="none">
<br clear="none">
</div>
</div>
</div>
</div>
</div>
</blockquote></div>
<br clear="none">
</div></div><br><br></div> </div> </div> </div></div></body></html>