<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Pasan,<br>
<br>
But from the DB point of view, what data type does your procedure
return ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2018Amsterdam">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre>
<div class="moz-cite-prefix">On 02/14/2018 08:51 AM, Pasan Meemaduma
via Users wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1535234448.649098.1518591115262@mail.yahoo.com">
<div style="color:#000; background-color:#fff; font-family:標楷體,
dfkai-sb;font-size:16px">
<div id="yui_3_16_0_ym19_1_1518589825317_3344">Hi List,<br>
</div>
<div id="yui_3_16_0_ym19_1_1518589825317_3333"><br>
</div>
<div dir="ltr" id="yui_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="yui_3_16_0_ym19_1_1518589825317_3331"><br>
</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_3334"><br>
</div>
<div dir="ltr" id="yui_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="yui_3_16_0_ym19_1_1518589825317_3288">
</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_3335"><br>
</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_3329">Its
caused by following line in my config</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_3328"><br>
</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_5015">avp_db_query("SELECT
uuid_generate_v1mc()","$avp(callid)");</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_3327"><br>
</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_3326"><br>
</div>
<div id="yui_3_16_0_ym19_1_1518589825317_3218" dir="ltr">does
this mean I need to convert it to string before returning from
postgres via the sql I use ?</div>
<div dir="ltr" id="yui_3_16_0_ym19_1_1518589825317_5033"><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>