[sr-dev] git:master:167ff2b2: Merge pull request #1672 from sergey-safarov/psql

[GitHub]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: GitHub <noreply at github.com>
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: