changeset 162:c2ea17961dfc

Running transactions in "Serializable" isolation level
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 08 Mar 2018 12:27:20 +0100 (2018-03-08)
parents 6c94a727758c
children 43d5a4e03e8d a1b07f1847ad 9e67a880d35c
files Core/PostgreSQLTransaction.cpp NEWS
diffstat 2 files changed, 3 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/Core/PostgreSQLTransaction.cpp	Fri Jan 05 10:57:39 2018 +0100
+++ b/Core/PostgreSQLTransaction.cpp	Thu Mar 08 12:27:20 2018 +0100
@@ -52,6 +52,7 @@
     }
 
     connection_.Execute("BEGIN");
+    connection_.Execute("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE");
     isOpen_ = true;
   }
 
--- a/NEWS	Fri Jan 05 10:57:39 2018 +0100
+++ b/NEWS	Thu Mar 08 12:27:20 2018 +0100
@@ -1,6 +1,8 @@
 Pending changes in the mainline
 ===============================
 
+* Running transactions in "Serializable" isolation level to avoid 
+  inconsistencies if multiple Orthanc are writing to the same DB
 * Upgrade to PostgreSQL 9.6.1 client library for static builds
 * Performance warning if runtime debug assertions are turned on
 * Fix issue 62 (use correct type for lo_read() value)