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
<[email protected]> 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
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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
