Mercurial > hg > orthanc-postgresql
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)