[sr-dev] git:5.1:039bc391: db_postgres: Fixed blob hex encoding (#1255)

Module: kamailio Branch: 5.1 Commit: 039bc39162e93db6719452ab60465cd7ee166f72 URL: https://github.com/kamailio/kamailio/commit/039bc39162e93db6719452ab60465cd… Author: Sergey Safarov <s.safarov(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2018-10-19T08:26:12+02:00 db_postgres: Fixed blob hex encoding (#1255) (cherry picked from commit 5557a441a4969994c2a82a89d53dec710164a034) --- Modified: src/modules/db_postgres/km_pg_con.c --- Diff: https://github.com/kamailio/kamailio/commit/039bc39162e93db6719452ab60465cd… Patch: https://github.com/kamailio/kamailio/commit/039bc39162e93db6719452ab60465cd… --- diff --git a/src/modules/db_postgres/km_pg_con.c b/src/modules/db_postgres/km_pg_con.c index 5a7225cefa..b66a94a0fb 100644 --- a/src/modules/db_postgres/km_pg_con.c +++ b/src/modules/db_postgres/km_pg_con.c @@ -52,6 +52,7 @@ struct pg_con *db_postgres_new_connection(struct db_id *id) int i = 0; const char *keywords[10], *values[10]; char to[16]; + PGresult *res; LM_DBG("db_id = %p\n", id); @@ -141,6 +142,15 @@ struct pg_con *db_postgres_new_connection(struct db_id *id) } #endif + res = PQexec(ptr->con, "SET bytea_output=escape"); + if (PQresultStatus(res) != PGRES_COMMAND_OK) + { + LM_ERR("cannot set blob output escaping format\n"); + PQclear(res); + goto err; + } + PQclear(res); + return ptr; err: