Module: kamailio
Branch: master
Commit: 167ff2b29d82cbd96dab3435c1694d6b40e245cf
URL: 
https://github.com/kamailio/kamailio/commit/167ff2b29d82cbd96dab3435c1694d6b40e245cf

Author: Daniel-Constantin Mierla <[email protected]>
Committer: GitHub <[email protected]>
Date: 2018-10-12T02:02:24+02:00

Merge pull request #1672 from sergey-safarov/psql

db_postgres: Fixed blob hex encoding (#1255)

---

Modified: src/modules/db_postgres/km_pg_con.c

---

Diff:  
https://github.com/kamailio/kamailio/commit/167ff2b29d82cbd96dab3435c1694d6b40e245cf.diff
Patch: 
https://github.com/kamailio/kamailio/commit/167ff2b29d82cbd96dab3435c1694d6b40e245cf.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