# HG changeset patch
# User Sebastien Jodogne <s.jodogne@gmail.com>
# Date 1520508440 -3600
# Node ID c2ea17961dfc4a1c73fe99ef116595761c344729
# Parent  6c94a727758c97289a82e1489bd33f2d07a32a94
Running transactions in "Serializable" isolation level

diff -r 6c94a727758c -r c2ea17961dfc Core/PostgreSQLTransaction.cpp
--- 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;
   }
 
diff -r 6c94a727758c -r c2ea17961dfc NEWS
--- 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)