selectall will leave a transaction open, call self.commit to close this transaction

diff --git a/PLC/PostgreSQL.py b/PLC/PostgreSQL.py
index ecc4ec5..674c309 100644 (file)
--- a/PLC/PostgreSQL.py
+++ b/PLC/PostgreSQL.py
@@ -221,6 +221,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()).