Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1wk3yk-000RlQ-0J
	for pgsql-general@arkaria.postgresql.org;
	Wed, 15 Jul 2026 18:05:06 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1wk3yi-008nhf-2R
	for pgsql-general@arkaria.postgresql.org;
	Wed, 15 Jul 2026 18:05:04 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <shammat@gmx.net>)
	id 1wk3yi-008nhT-1C
	for pgsql-general@lists.postgresql.org;
	Wed, 15 Jul 2026 18:05:04 +0000
Received: from mout.gmx.net ([212.227.17.21])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <shammat@gmx.net>)
	id 1wk3yg-00000000QvT-0tCR
	for pgsql-general@lists.postgresql.org;
	Wed, 15 Jul 2026 18:05:04 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net;
	s=s31663417; t=1784138701; x=1784743501; i=shammat@gmx.net;
	bh=YDeGSv/7k/ss4ZXEZKQptqnLnkYYU3i98ZJRMmsgb04=;
	h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To:
	 References:From:In-Reply-To:Content-Type:
	 Content-Transfer-Encoding:cc:content-transfer-encoding:
	 content-type:date:from:message-id:mime-version:reply-to:subject:
	 to;
	b=KVIwubaNBT5EPAlwb5VCxlmyZ1xtKQozQAu1gr2oIf9NyvKk+PYdDl6S/530WXVu
	 tgkDSBFvX8NVedCk/c8ZKlTkeSOCqe5RksMe/RUhI+MrxiwX/3wPK8Ob5T0h7BwoI
	 iFPv376cT3OlqfDfyUw+uODP233OKNRY3462FKCCQ667GPpRm04QTD8GvHTCQmZNx
	 4diWmJwRwCbf1UE+0djA7wcqbMdMJ4cKnaAiMTY4svdNgKz+d+oNOy40cqx7tDHAI
	 PLnBeJXBTgex0ICWfK2AMSnjCxQi4z/D3Mp8MF45Nwg/5jH+clMyVJbnpORDPtHLu
	 HF0LesdKj5G3Ez+eAg==
X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a
Received: from client.hidden.invalid by mail.gmx.net (mrgmx104
 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MgNh1-1xF0Xz3WLX-00eYyS for
 <pgsql-general@lists.postgresql.org>; Wed, 15 Jul 2026 20:05:00 +0200
Message-ID: <23ce3f85-6f66-4724-a2e7-7e13e077d423@gmx.net>
Date: Wed, 15 Jul 2026 20:04:59 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Transaction Isolation level for ERP software
To: pgsql-general@lists.postgresql.org
References: 
 <CADWR+qdOYKvq6WCUsB8bs+V_5DL-qX8B_b=EbHiatvOimCfaYg@mail.gmail.com>
Content-Language: de-DE, en-US
From: shammat@gmx.net
In-Reply-To: 
 <CADWR+qdOYKvq6WCUsB8bs+V_5DL-qX8B_b=EbHiatvOimCfaYg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable
X-Provags-ID: V03:K1:dWtK8pKgs1llFiI7UZfXPmjS+iswbF4B8t2sMcKo7SuD+2t0n3E
 iEnosqesFP96xrjaLcdWcfZdgC7+t/Q+7WdBu7Fnbe0fkcuve7b0+PWZqhv/Nnz9alQzkVb
 T+yATt7+UJ3ASR/jujTMY0oCH3WBKQkqowKeChPs7jd7wHZJubvAJsGTh/cvdubfOt/+e+g
 /euvDFO5lJDB6qQXIPd5A==
X-Spam-Flag: NO
UI-OutboundReport: notjunk:1;M01:P0:agJKPGN1bE8=;Sfp1SdgIHkRVppLypBr6QnaVauA
 /sVirn1e+Dkcaw+lL8bD1I3Q7GXtg9fozj+l05ogul4CQooOB4ujFxxgv2SxJTLfyOZW1Flx9
 aeLqX2WQ1B+EgxC5RxCV9vNUZSQp0yuMRuJH+OtDk1ENHYvqltGqFjG9TuE4eswxDznts+dTa
 YVGMDKPRXPzG9N5OU1v8zP+9ox1V7Fhk3cGrXrLMyXwXrkfC3k0Hx3frHh+rXfEq3tprV1OC/
 0Z0mLFgmLgTeee/ztWqTe1ucBk+DMG1+VQSpaBeJkL0smJ+9BR2KK4YBh2OiOYF1TipqRGCsV
 QdDVNKFHBZDBKUQDoonLY9ANL2CjO1W2XVf26bJgySOuhysaizk10W0PWNC99IXfq2waR84Zu
 tbXnkpW5WXCpiep12aRwmVyXhWF32N3KhNHjrty1ZA1CVekeauGo4k1b6UiZTRRw3X7upUEOl
 YXKL2T1HnDAljTEKu5HvXkpz+Zd9DXQbZ+FW9fN7pS92SUrGfw9RNzTjVTiCVTiDG5wqoXNor
 NEqxNZA/vJMRehak2cE5wIph2rQ+h96r76cm4tj+zFKs/Us+qUlek3rbixG3WtTJW5/G9u8AO
 /+5Rzm6cqro0FT7htq2rDr9i3V7x+etPJFJGRiqT8TULz0Jb0I+nNGw8BIy1QCKCTCdwZSmNe
 ny9a28ufQ2JprLnrG7Q3VEj56OPybCNRd5nvxkQHpDX6FzP9jf3tCodZ9Is/XmxPMeIEwzc0a
 S/jg49cQZQiEeKTWnxAdg7jZ7mhAz+1M5T2n9j9tr9YIFp3y7o6o0rLEOHkdKCfhEETl0DHI3
 5+3ibktcslPcQWF5rAElyBJNDAH66fIAbq5Fnr1Wh+E1mWtz8O0elDFFSOAj5RQF1Pj/u6rjB
 lkJ1qHTUWk0mSrZMQ8h6tmPfDZIVmt1lbbhLS1oE/rtmamY6YOKlwpt/WlN331JlEXzIhrPHv
 7iRneCwLjUJ3n+OE3jBOdj9+4QifO2ZvgGGZsiRnCbzObe+U3sCTHM+25CCsheVpcqdFUbht3
 q64C1VrQd2KCMqbdRhH+4Gtk1SsrrO/Jdy05f8nsVidIV+mZBzpGFEydWabamONWrJCamUevL
 7p84BdJ6IQxGVK7kL+xzGED9Utagpo0MY/SQbCRTJDOuXI4fKm/2B56LHfaT+H3rLEA4xSxI/
 +J7qChJRjEpY1FxpisfsYUPZqLyiCXp3ww0hp9HO5NcdGT0mHBDeGCD50lm8pwDCyJoe22oTx
 Iz0IhgE12WYJvZincujtgqlHw5hNuhFitqcBEYZ6A32v9trYyuPlDWOjwWta+YZAqtUFGUGZs
 vbTLIv9lpnFFe963Hh+cZxQYR2sSMawaYhcQtLPifg1DUodbFZsGQzvt94gmodTpSArcC1B3C
 zi4pT1sC1Ttuk8uyvVwVVfANSkbYgShUwVivKsTsfM2Vwjnp5uvVU3KxfbxRKv20Jx3NYDcR1
 3HMoSUkWBDR3ce75SrY5ojtd+7Ck2MPlfPi9fEUMpXTXMo08Qj6xBhMjy4+MrAQ3CYuoOgYuA
 b8e974A3rVheCPK1l58TyauR9YdNAkVELE3Cb8m3YlNx7ZaB0t0H3FIJEkEtATn7lYVsDRvCV
 e8uAPpe4Bh75yvOcJHsP8bCjET+JY2AnfIorjJ+FGjnwvulkYjpiUtNGm/uYRCLe8MSNY82rw
 eZ5t8vS4xl28PQLQcUtQZRs1aBgKUrLeT2KwX56PkDZLTkcqE6+QyidI5HXMPesA9oRp+IJXV
 M6QUujiULP57B2NUi/rvY4WVtgy2v2ceYcqPI7+koUdp+lAH3vZbsgNoZxi9Yq1prfO4B7ujw
 u76sTD01ObbvPkI+9qMIBUnJxIleM3ak51yvVKpCdeeZPXDDmzYANAIlsuyuzitMOhAhEDPQ1
 xsBJoF7Grc2R5grZOSv02HOfe5aCozPoyCRrF5Y8kVLWx69+ZyCcqlEkkvM3coNKKQ4iETTIF
 7hgC8LfqlUywxsZttoO/xy1Rib1nfI7u5qqSqKlaitpbqb5aXRdUZdrUiCBK8T2WN5AydaLtE
 DsuedinEBLIBmJHoAfZsYm0i1vaaLKNX+yIbahm8UZuVPJn6c4yFvx/+aS2RkgvCx6TFT8fOr
 x60bkXSonbgzE231voK65QC5rUEXHnXdUIfwPnTBeB87XIJ/y0uB4uxV0UJGOElpARTSyezAD
 sFDFXFhe170DHaif8Q1Ze4HlJlIyN1HyxOQuCYTCTtydeLEBar6em99zuJVRqUzmSZVsWzYVU
 1FWZlI9AC8xXWHgfZi7gvPwd0k97XUBnrqv9icaEgcxwoP7V+WGcoQmgWSWuG+q58e5JIFrzK
 unC5JupBd+CnX6+beSRB/dmDE0t3Ik4iM8NHJVDiXQiubOBDXSBziB25ZQmRb7P6+7j90dknw
 gGDpN4bGNUdlsE4Ltg7hmr2Dq2R5l3yvr6AED+qoSc8/SGxXLmN2X9gLzdtpdIXZu3PuLPuVx
 IcsFJzeHg1XO4n+bjS7/dsk4Cto4vHX/1bz1Vf4f5x0Ze6fZ7xAbQ7mENnS+33pOAfPM9sW+N
 aSxWEbmPfQZQ6epK4+sd8055TpC2PU1BXkmEDaGsadAsmCZYO5Ent4y9cGtkE01J7j1LHJk+G
 7LNdxxq74t+uExowExMfpUZwqLKFznGs7pzcjiBG6OzvnmZNVv/9h3Llh3ciQBx/BBzfa8epg
 lwlpIzQ3GUes0iuzlOtUgnjucY2G7cbVsQZUA7IYieQyvG/I98W5lcnEBizOvitoI1CD+Mk9O
 LBZNYbfLAxJlfeg5iX/g3QHKEycKhiATgINwD6RcVcZ3wa1o4GfGLiwQdcp4qIdBeQDGhcVPC
 O/3cA5XvCtgJ6xdZthwDyaKGhEKGqjBXsgZl0tGQ06jR5Ch8RnQyzpYz0MOLXkwUyr1N332Eg
 RRnzPyqXlf8L/zvT+9ICHXguD34hXCOYy8gu4Sm1BNQjGFfjCk2/I+sXtlbZ9FCC6iPEaEoxx
 CJ3VRMXfRCUnEZRgaBvMGBKmuS7YVg/lKgtkItnFfZQdI9J1O3zl7SNmF93UwZjjnyLp3WU0u
 0KUxVlMJXAyvoVOVdyBSgfe/pA+KpqPqVhbOLwV85U1hESBLM4Sx96DKk0psBp1/G1ny2Mhma
 Re5PlkC7TVb7CYFY7+mWlpXQj4gK5XMdiZfpSPVF3STnfq6/BkHV/DNJn3SUoDxDw9/WAj312
 a2gJ8q7oizZAPnOp6C77W0REskBxxxIwQP6ATto7l/R5C45ZFKp1pBC0KAOFhZlUnKpjyQuUW
 wmIGrggH+WaoaF+sPHVrz55hwk9WXaQWAsF4niiUYCW0iGX/2brkIu2Z22Z+N8qf2kL4q7PXP
 +eq9h8hKqcB8ArxmeFy4hEWUoCo7epGm4QXHq9G8WU4kzD5lamz3j8HybqVckRUIIVfJ77IsU
 gOA88/9ItAMGBGQDftWwvpPh9SgFl45kgq6P3Q+UeAYonoJkLeD5C6uVW3lrqfVpnnh14wmgN
 1VaH3N1x4vdrQ1szJVfutZ0cL9t7uRGUmeKbTlTBA9jer3qeQh57X77Z46KXt0adUwouyZjXN
 AB4tDvkD3zLD69eLE1qu/Oh2eiIFQWM7sR1kxs4H79pFmShz86c+FgPHMp72Lyg/iZ5VXVLF1
 N57tyeq1Vg42uNLQUhtP/n0ACgdY3nWIJCInwbyqzsb9F7e2N7dWrOzM3nhpjuBqC9tLfJnlj
 mc8NTJqqYZ/8eFnMZ6T3/ytS2P8p3qyRU0l5rG7K1b0YkJoVIkglkcTcXPoxcwjWiSGVCNt74
 IbQC9yFf9WE9lvLrQHRJwzXCGI/CvdNiTZuOi1gZomXVmiTXZ96e5KizWVsgVhTrOSp9Kk8iN
 Ed14c+Xghb2E5Tve0PslJN2wOt9Uva8LEJ0DMCTNV0aYn3FYwoFR1nJKDGvakt3HdrTt2o0Wx
 pbzFXEUO4TyUT4mGNr80+rgY34uuRqWbmnoJ0pgLecHt1H0QSSIImqMw+HJtjYhbcOvpQ1awB
 Qf7T6ubisnACT4oJC/D8sfy/hpkITSg0q9EJaX6bcrBVJTmgs3ztMBd00kZLxT5T6HWyLS22E
 AQN65P6SX+Qv46V70ZpT8NC4qcdCywS3+izMMO3arWOg1I9wBvTTItBykDl9Gb/+/AkkRioFx
 zqZ1DIuKG1PW91/O+l7uTNTZpi5MHrBVtLCoNekSYfGO+F+tx2c4gSzsrMiPNwtCP6V2wnoer
 iTTkk6q18wZgCjuttwepWQJHi8Glrs4ezsb6J+HN2vcqyeWuLp5pbYEQfRNF25v6lW3zOhV2z
 2tUFymRWsDf6oXWo0wBR1of9q34/Gy85tzOCyi99KK0mzWSi17sOJbirCY7CA1TCTfAbE0LVT
 Ygv91iw8/v+FKFGTyxdJjm5RHusBLx57lVQGxJKax4CFZ9eQ7eIf/Drv1u6lYl5K1kNuwRE0Q
 eXr6DZXXyN3V83kBfF3eUYmQcaZVluvD8DtnRzQlYtAz3Qqmng+PRw7EqnEcqyXXQKSGNegKs
 VFbYJUX1OG0INBHO65EF4Kk4BO1DOinXG7E81bkIIg2VlawozEBGCv1YI/Ysp3DmrJarA+sDM
 B/yQsnnXLaNbAlwsNgY6kF9+YTXJmrKRRwgk6lt5eMhiswiaEAFR7pycFBhwoenmKkimgxHAl
 O1R7C3VB8Fq2SfNaq0MCvGVNqIh038XAqGUbF9uKaoJKO7eDk4e9MjpRDyT3KOU5aJiqvgNir
 LADefBJv872R2Sw06BvGyM8BND/2u3Zll+N4hlVmQO/XezDL7b8rywXEFJ3vXt0pMeHWGYeBp
 YipHPqLOKZ8T16A/42rMnADx0v6kGP8ZKwXWtKzyv/vnqjdIkkm3OfRKCkHeX3riXAzJpylAB
 tLGDdTuyFIPEyziD+CCAHIRMkMXiZB65PCo9UWyw3ssGYpbQMZfay51cFhM6LzBBxw1734kP4
 hIDDnRYSqV7EQ8axwuWQnq2F62NQQ1+IIB+r8L4LpiZUzrr9JMrr5e31dJgP6GZFZ2fZaVywL
 /wcxjfmvnVrlo4KLBw3G6wqDXP5bFUje5IINJftKTxOqqAxgDuhw1xBv7W3riaj93O0U9rbtC
 PnwARCNYwK1iFnatZYfO00lwjSRlGeT35Qv/uJ1L9asHzyj9VOS4W7sXU+cUkZtGuZW6YmP30
 ZEOfB80P9ZO/63Sm0dXM6nXbuWBT54V/D7ff50bzFdudATlxtmoQOHJ05/T1wXJ1AKXy3Rc25
 0Cm9b1FcQxq55YfNxbW8Wg4qLbMLAuM+7fIP49ohjL3DzyV7PVRJUIkhumTuJ5QlF4sTSXSkw
 CZbxNEucNo6/a02QrTFC0pi7EP7draeyFlMiiMzbqXbF/nT2g2gEd9brmVKSLiDTKY4sDVjLl
 sgXYYM67wLTlvdvS1kj0H0qn2Ep/sRJDM+FHjXNE1CixRy9aRewLa0uY5DnaeGC+BA8NLSHe6
 9/XKLtbqUh86A/kQ1wkFkBhiUBggG35617ZauuHRgm5LomKO866SwOfntv0pZfMh3f74v0aPV
 5+u4y7yBMxCfe67IrqTwMdXDXZDA9E3ryFsvjn4qvmx7seJnyKa7PfOINJKJhWIlM1wepBqSg
 fOahHw==
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/23ce3f85-6f66-4724-a2e7-7e13e077d423%40gmx.net>
Precedence: bulk

> 3. READ COMMITTED has its own set of problems=C2=A0like gap locks
I have to admit that my knowledge about MariaDB's "gap locks" is a bit fuz=
zy,
but I don't think Postgres has anything similar.