Module: kamailio
Branch: 5.1
Commit: 039bc39162e93db6719452ab60465cd7ee166f72
URL: 
https://github.com/kamailio/kamailio/commit/039bc39162e93db6719452ab60465cd7ee166f72

Author: Sergey Safarov <[email protected]>
Committer: Daniel-Constantin Mierla <[email protected]>
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/039bc39162e93db6719452ab60465cd7ee166f72.diff
Patch: 
https://github.com/kamailio/kamailio/commit/039bc39162e93db6719452ab60465cd7ee166f72.patch

---

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:


_______________________________________________
Kamailio (SER) - Development Mailing List
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev

Reply via email to