Python handle as string all int8 values from postgresql. This could be

bmomjian · bmomjian · commit 076026bba990 · 2001-10-16T13:42:57.000Z
view when using the aggregate function count() and function nextval
that returns an int8 value, but in python is represented like string:

&gt;&gt; db.query("select nextval('my_seq')").getresult()
[('2',)]

&gt;&gt; db.query("select count(*) from films").dictresult()
[{'count': '120'}]



Ricardo Caesar Lenzi
diff --git a/src/interfaces/python/pgmodule.c b/src/interfaces/python/pgmodule.c
@@ -286,6 +286,7 @@ get_type_array(PGresult *result, int nfields)
 		{
 			case INT2OID:
 			case INT4OID:
+			case INT8OID:
 			case OIDOID:
 				typ[j] = 1;
 				break;
@@ -1793,6 +1794,7 @@ pgquery_getresult(pgqueryobject * self, PyObject * args)
 		{
 			case INT2OID:
 			case INT4OID:
+			case INT8OID:
 			case OIDOID:
 				typ[j] = 1;
 				break;
@@ -1940,6 +1942,7 @@ pgquery_dictresult(pgqueryobject * self, PyObject * args)
 		{
 			case INT2OID:
 			case INT4OID:
+			case INT8OID:
 			case OIDOID:
 				typ[j] = 1;
 				break;
