Mercurial > hg > orthanc-databases

comparison PostgreSQL/NEWS @ 432:8b7c1c423367 pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new 'TransactionMode' config + rewrote ResourceDeletedFunc to avoid IF/THEN/ELSE pattern
author Alain Mazy <am@osimis.io>
date Mon, 11 Dec 2023 14:39:27 +0100
parents f1f3c5554283
children ff84104f7842
comparison
equal deleted inserted replaced
431:7c1fe5d6c12c 432:8b7c1c423367
1 Pending changes in the mainline 1 Pending changes in the mainline
2 =============================== 2 ===============================
3 3
4 * Experimental debug feature: 4 * Experimental debug feature:
5 Introduced 2 new configurations with these default values: 5 Introduced a new configuration to select the transaction isolation level
6 "ReadOnlyTransactionStatement": "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ ONLY" 6 "TransactionMode": "SERIALIZABLE"
7 "ReadWriteTransactionStatement": "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ WRITE" 7 Allowed values: "SERIALIZABLE", "READ COMMITTED", "DEFAULT".
8 You can now customize the transaction isolation level. 8 The "SERIALIZABLE" mode was the only available value up to now. It is still the default
9 If setting these values to "", no statement is run and therefore, the default DB or server 9 value now.
10 isolation level is used. 10 The "READ COMMITTED" is possible now due to rewrites of SQL queries.
11 The "DEFAULT" value uses the default transaction isolation level defined at the database level.
11 * internals: 12 * internals:
12 - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies 13 - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies
13 * New "EnableVerboseLogs" configuration to show SQL statements being executed. 14 * New "EnableVerboseLogs" configuration to show SQL statements being executed.
14 15
15 16