Mercurial > hg > orthanc-databases
diff PostgreSQL/NEWS @ 432:8b7c1c423367 pg-transactions
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 |
line wrap: on
line diff
--- a/PostgreSQL/NEWS Thu Dec 07 12:13:43 2023 +0100 +++ b/PostgreSQL/NEWS Mon Dec 11 14:39:27 2023 +0100 @@ -2,12 +2,13 @@ =============================== * Experimental debug feature: - Introduced 2 new configurations with these default values: - "ReadOnlyTransactionStatement": "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ ONLY" - "ReadWriteTransactionStatement": "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ WRITE" - You can now customize the transaction isolation level. - If setting these values to "", no statement is run and therefore, the default DB or server - isolation level is used. + Introduced a new configuration to select the transaction isolation level + "TransactionMode": "SERIALIZABLE" + Allowed values: "SERIALIZABLE", "READ COMMITTED", "DEFAULT". + The "SERIALIZABLE" mode was the only available value up to now. It is still the default + value now. + The "READ COMMITTED" is possible now due to rewrites of SQL queries. + The "DEFAULT" value uses the default transaction isolation level defined at the database level. * internals: - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies * New "EnableVerboseLogs" configuration to show SQL statements being executed.