[OpenSIPS-Users] warning on postgres data type

[Bogdan-Andrei Iancu]

Hi,

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.

But, why not using the call-Id + from_tag as uuid for the calls ?

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   http://www.opensips-solutions.com
OpenSIPS Summit 2018
   http://www.opensips.org/events/Summit-2018Amsterdam

On 02/14/2018 12:03 PM, Pasan Meemaduma wrote:
> Hi Bogdan,
>
> It returns the postgres data type uuid. I put that in acc extra field 
> to keep track calls.
>
> If I use following, I'm not getting the warning anymore.
>
> avp_db_query("SELECT uuid_generate_v1mc()::varchar","$avp(callid)")
>
>
>
> On Wednesday, 14 February 2018, 14:55, Bogdan-Andrei Iancu 
> <bogdan at opensips.org> wrote:
>
>
> Hi Pasan,
>
> But from the DB point of view, what data type does your procedure return ?
>
> Regards,
> Bogdan-Andrei Iancu
>
> OpenSIPS Founder and Developer
>    http://www.opensips-solutions.com <http://www.opensips-solutions.com/>
> OpenSIPS Summit 2018
>    http://www.opensips.org/events/Summit-2018Amsterdam
> On 02/14/2018 08:51 AM, Pasan Meemaduma via Users wrote:
>> Hi List,
>>
>> 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 ?
>>
>>
>> WARNING:db_postgres:db_postgres_get_columns: unhandled data type 
>> column (uuid_generate_v1mc) type id (2950), use DB_STRING as default
>>
>> Its caused by following line in my config
>>
>> avp_db_query("SELECT uuid_generate_v1mc()","$avp(callid)");
>>
>>
>> does this mean I need to convert it to string before returning from 
>> postgres via the sql I use ?
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20180214/a8963e7a/attachment.html>