[OpenSIPS-Users] warning on postgres data type

Pasan Meemaduma pasandev at ymail.com
Wed Feb 14 01:51:55 EST 2018

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 ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20180214/e1c95bd5/attachment.html>

More information about the Users mailing list