avoid leaking transactions - merged changeset 12836 from 4.2

diff --git a/PLC/PostgreSQL.py b/PLC/PostgreSQL.py
index 172b5c3..9dcae20 100644 (file)
--- a/PLC/PostgreSQL.py
+++ b/PLC/PostgreSQL.py
@@ -222,7 +222,7 @@ class PostgreSQL:
         cursor = self.execute(query, params)
         rows = cursor.fetchall()
         cursor.close()
-
+        self.commit()
         if hashref or key_field is not None:
             # Return each row as a dictionary keyed on field name
             # (like DBI selectrow_hashref()).