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 ) id 1wkHa0-000Zsl-2l for pgsql-general@arkaria.postgresql.org; Thu, 16 Jul 2026 08:36:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wkHZz-00Bzu5-2D for pgsql-general@arkaria.postgresql.org; Thu, 16 Jul 2026 08:36:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wkHZz-00Bztx-0n for pgsql-general@lists.postgresql.org; Thu, 16 Jul 2026 08:36:27 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wkHZw-00000000Tuu-34vb for pgsql-general@lists.postgresql.org; Thu, 16 Jul 2026 08:36:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1784190981; x=1784795781; i=shammat@gmx.net; bh=IcvECbAnpUYIJIePTnW98YQyRznmkOf37uv/Mn1Kqcc=; 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=nKtb2UhbAg6nYCDLOM1Tl5LgKlLEfteROT060u9KRQq1KXnO+KZ4pmEILhRzoVjb UZVDlp9CFrckp0aQw45PTDJWuNg791OAmN698hFHlHKD2KXsmfE0NtHN1nHjjK2tW TS8VtlNMdf6695kmJhpcXzRxsKYWDfNeYIYunWMHw3IPeWdaVQYTzt/0+qIp0/8gZ iUhC9xoNPklJ4coYi0MrAsyS69AnE/dwpAB1XnE5+3by9cKEk/XESmIywWkOW7Luk yXA4UhWi4tdlWca/eezQlsShCzcqrmItcxvuMhLzNxwP24I5KkJwzms84aSfPS5ic fXOOafQweM19avXlIA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1Mg6Zw-1xENH12AMo-00lBjT for ; Thu, 16 Jul 2026 10:36:21 +0200 Message-ID: <970e7d80-67a3-4c1b-9a02-e1e72e3a2cdb@gmx.net> Date: Thu, 16 Jul 2026 10:36:20 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Transaction Isolation level for ERP software To: pgsql-general@lists.postgresql.org References: <52293c938269ffa74a909c4599e12622fbe84628.camel@cybertec.at> From: shammat@gmx.net Content-Language: de-DE, en-US In-Reply-To: <52293c938269ffa74a909c4599e12622fbe84628.camel@cybertec.at> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:7bicc6ieFkz8zJaIoAZN16cp67NxnEhSnHfB1ZAZoJ93ekmGQu5 RB7FPDqFZbl57Nrvq1eQWl6Xk8rtG+FuqSJ+I/57d32suIcaZDoUZNVGElbKOPwXxizYLcm AoCDOCJBR42LigCmXQOl6+//tYV5LUw89m54VZ2+01dJ0aI9nFhN3iyK5HcKOYx7vOaIpFn 5mDAGPxWnt3sKeBmfqZ8A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:9iOMvy5XYH4=;l81LWLlTGWZGu2DEEd5fBtDHf/o EgyZasdB8DEZlZxYdqe52QcQJF5hefGhQQuDSqIkaOkN/YLERXGvq47m4ynaNGKxRk/07s5YL 62rIraRXvF4w+pgeQ6ouu/vvQOtUU5yOsx7HDl9bD+llElxYE1Lc3Lpk++rRBltufcVE3S7i7 gLNhF9edNj5wxUaZMFuaM3lRici5G6BR/MmNCIdlstTZEJCllFfDvvBiQtxNZT/fzq2enTPoi PtWTyNBJFcoDZhy5AqWwkcTFQIpWGSJc3OZS0y1QG4gv7IUpuSXaJiPj9dv1W4tg6jp8WJddI PE8RvK3pddvJG6bafQiXOA0MaQsa3NaMeesiP2vRvOfBhd2JLWZ38rEwBDaCiJdYgJKroDDP1 iErh3ENNj7bkplQE1TLo+mFbb+s0MBwvV1/zA9d1tOw8hmI12nkwVl7g962oZ2jbadNrWVlwx 0a8KUvTjrhiceh6RZZS45Hhjnh9NtRHcDCmvyfcnFLM6+rEI4IZbNA4rgBIhFmAO6ynKGXTeJ WMUzFKEYypeAUJKcrEgBfjZkwWcXZoIbEf0fVdPD3xl4U4f5q/ZhoCiuq6diTtf3cH/RYdP38 WpwHhZTk5wyicQsuXUim8ixfsaSkJD0Jc0HYduUxJbrEtofGrqdDQMbYHC2IjkcfTtGWxOK1d 7D3j3QaAMR2rWvhZAON3p8zEdnAgvwtvEiybIdfc6uFcC35xN1aIA7XM1O9KoZ5skIGlYNDEi nVGwhsU2i7hIfbb00N3Ybt2yDjlKgB41ZYdfESx0CJd3NJyyoS2qksXHjZoKSLW9xgAfUL+rz umLvvVqwwv6lDCjl69QgyPyMJ4RMpnQ3W0Ot4KbmUZQWZo9ZhOm6/pbGSsDK9gUQRYdYCs7k4 uTpuPdXqQ7APwYPyq7ORUBhhg3SqxtxfhfL0U9ZGhYTVNB0OYkXKeeTSWFloXDkq1bzgPIpCH b4n8RKxKgJBtso3jQugAEAH1fDT9oaRG2tqFS+E+AwRu3yIAMDVjMFpsHxFOgxLWclLATEqLQ fsE7kDqidsHqwRl4oumMN+2tIC61Jc5SqJ+LOz8tYFEPJ9UrI8zlD7pJ8DGSbXSZDj7yYwRFR x5xqllc3RFu0EuBI3ng3VJM9WsSUTxy5LldEeFwqB7uoHvhjZqsx9RLQkUIZVobrB8T+dwxmo X4C29IiSTiUVwq3iPjewYDdXjHPEv1dKzZA6vvszuQIbyyF7n2wNZ0tTJlQnaVHBvwKFLgpMc 4rfH0Ul/ln6MfmvLy5gKk8d1LVWitG38NpPWRGfUsJNvl3YE+BAUP0ql1vckv/vH695qSaQAj uZPWVrWMphDMunNLySQgZhXZ55+KAqKdfjZ5amyBmgFvNFv3buA0N8vEU9mZ4UHf+Ii1F+hjB bKM/ywbRsl+Q1CQSRnyLrJTeGO0hdChsCKYV/XqCuHL6qJerLgPjYfWAVhkuvqmFszQmJw4V0 upKIcMsdTx/o5eZnCHWVGUd2baxRJC2S1veY64KrVqYQWO8xHe5oFFbjZcVbBctj5O1QG5h8g qFsLg0FO8HxeZ9JkxYXlOr6IXOOV9/Njg4+RoygK1t4VvSfd39snIlBxUFzODOBitqkuTDoZ1 mCGa4x+KPF3qZdL6iCGOGy9C49f+99YwNDELXs6IXxPSY0QGdgdFq5yN2lcE32eJBBxkQr/na prXOPvQZeQjGIjcl1m63ibhgTWhTP+PoNrpoYcdEPs5tdo8zl3zRE3rtNL9ko8+OYOL6E99fP a15gxcEltqrWkkbXdrsaW8sm1w06Y2p29Rgzk5cRxF7tF4KfQtX96ACXmjaeTsY++/p0QSs7L CetkNoCqp4RKJePyn46uxhUFiN+NfyX1GuRDpwaPZT57Cy72nhAdLYCNcTjoHcNwfo+GdZvNL MaoGjBa4vEdlDY1MN8XOmnCu6SmwvW97zZuNeQJihVvUIKFrgS+8pv3kwuDX17kPcWI2iuQQd /9+uNjxG24I8nPS81zTzORS/AUlj0dQ/7X90oj0YmrVHUTOll+O7kfms3GHBSzArgnXCTfqmh TuTe9KLYA1UoRU2iBpV8La+8pGlbN3+FzJVFnKN6MnjgSZ5E/vc7sU6M8QddAJzwwRmcftO3b mhSq+YM5UMGG7jOeCBFVah+RGGXGxfENI1/wy4pr5li6oeue8Y5aZynMUeVfXhtizkGhNCvcB dUFKA4PEaCtzgNLY9//JgF9Jug/PY8wQv0zYhEJL3MR6HagWVOWfKB8R7kF16FBaedWlV1Mj/ rS76oIPR9IeL/xdTFzGtjfogNQ8KyfIFcHi04b9fTlbatmzQ645+2UhCdjj68+At6ZBFpvL50 dJ1gEqBhZhXGH2cjLBZRdrOcLJag3Pml7Q8ehKyEPmN0jvlxzRvaAxHKb7GoncEzK25vp7hS5 EPWjsF8XkWrWEXbTjpBdMJZU5LNkmwmRuWOg84dNeEVbzjyEMZlz06UgkzYSU7uz0x1iXq1pI rmx8HOqkCvIg/NP9PQamgSquY1GHpPwMNYY1sWghFxiO1jdIox6wRIuVrbk8vv8Q3Dir1oS71 avyyY4Wl2hKMUrm2x3KAUW/sogbwCkTIxiqaapBb6Un/9uWiRLNQu9DiNDeLXQZhpmv+PYjPu 6joFXuPnOYsGq621KBJnz/Q6u/w8k5bTMLD+w0XQqWVnsHIAMcvj1RlEaHWd7K1tVtWe5QCoc Kq5fzZmJYtwtEVRKWxRh2CX1mqfj5nSKkLEQb7WWwAkyZJgKylSl90WPN/5yVXoCRZLpc75ef 0iXv5Gz8+dBLJggLfRpe5DTz+5mpzbSDEkSDOUl3hOo4yVPnGhOMtpRxJZ1eBjeBQY6XcjlDK qbeDsY6YGjxKAMnI3OnQIYh057yT1+7VwPQPqhuQ2pMw1d4AECQMLjpTFoKnzYqvQf2js8dnp NqiJJCzLO/J7dtXhKQvvcuL/MA9Z19u1XXWtJ98bZiU/3IwP09UrmKlwIKq6SJ/KFfr8DxgqZ 4bc1habXZYw+ogATLT/DGe52yELRQR2AtY9uHFMIq/dE65OPQHaYatd6wwVqfpXvt3ZgJ/Ra9 HcwX7N8mlKKRh76wADc/R0FlsuriD2WYnv0pv0anCauXAJ1YDP/tIfL1Vx0yp8jtIcrBZ0SBK 5ejJo5HebvDaiqASBlUjspzhEYATEhdPkm3c72EqCHCcKP8wT9QYuVyJqSyxhuZfdkWEPgBzx MvAwA9zyPmDxvT9rPxtyRr1Ckea7ys6tPlT7Xjpy0a/Vfxtd4HFw2gt4d2Kl9+Oz0GyYVhMxO m7w4q5ZYAH/Sd8WbKncEJAvYq9pTTVMAxx9/L/DtzvstXK+NVTCiX5UFfIT7VcFBE4wN5LKqh AJ5EaaFbv+1liB0lRBdOUwJnQeZrBdZgdmsKfWW6GpBtz5vGXC036IyKYXWnvbl+JDeGdvEbv L8sT5zdjVPto9I/z4rhZdYTjdTF1YluZKrf2WJW6dDhOp6swJb2Ka5TPDXaxvtkXDOylLRTSq 7y41QOwjFkOt0q2qCbs/OgtSdixw6YNn6cmyqwhuyvkDTRWCVUtFC48WDlX14UyJRfwaShI5D O3PVADoknrRIfay+SYjDS0klxIyuKgr8vR/GyW4aBvMlIxpQuTBT35is5ZCWzRI53J/gqom8x 60U5C5xJJjwErpa9lP6XuLh6smddnitGqpcOys2tdw5DRSO2/ddqQDQ3cLJiZnASfQvq+P4VI 9oMkYMmtk7qG2HeELpWDHVcBLbp74JPh+gm7xucwMtRBdBkGOHeNpbzmC6ROnqG5YyRGTsuSJ UxORl0w5ee6Vp2vd0cRJ4j+LTvwc6bAvHtcEZ1ArTtx0s7kyy6MzDLgO+kKGbQ4qhhFUGXRA7 ixWUMPdxG6kstv2Uno1ZkdI8fbhyLi/htQV9fph+yqqV2dILaRFh95tOfF6RW1sD6KhqwqMfS UQiGGDxfgN1WSJ308txG2YpvNKbJ0fXrkoc8TyiNksOIhxaWZe+RC9mHul1A9wxXSFf4j+HSd c46ebg3up3yyfRHHtmvNzBcaInFwXmupMmnMJKpFOCQACRImGZBxARXy3Ngt4eWDnBspXrPpt MLB0UYNw6ItBErPQkXgrSuw3EK3Q0urtFMfaaisrvLFOziBD8kb51k0mhmBWB/5f85qYgjGLC 7eP6rOWhkRNaA7ijwQgBpAsmI+7hKGyVxAz4wH73+wzdqLtZTh+fLwFXDxnxPIWCnvd8ukJiz 0mvRfsi+g+5GsSE+pPWUOxNVv6kRQ7E3P2iIcTsQAaIp6PyYVswRVnIH4t/P1uX9E3T168oOP Q/28DD0mDwfplkHmMp+it3F7fSnwNitPskHn2Yi+NxQtgVta0u7gaye/wXqBW8rKQGVMWBqBd CKT8mKcrNpWwPoxW1JLehDb/eKMofzz8qVG/w4sJ0C6fpz/3lUrr7RnbzedzCUP5l7EG2Ibb/ V/IQsGoE7QZ14jlbF7ytASZOTiWGW0okpsTwyQkJ7snhS27IkgVKrQguqglh8C1cRAVLG8rbp D8dSi0AlEEYM51u4/innVHzzQxSy6zT2c2c9qIL+o2/iSZvlERBkJIsMmqhn0Y4FfA7jEIGFV 4sHEE+XN/NpLrkClme+N+93qOLP3LuTlTYUzgTcJoolvhiC4Ho/z3PRC8FnaXJ73pm1olm1jr MQ+b9MO83QO6AciKT62ytJJAVnNftTf4D1GFE8jRrSxUhTbBI1IDnXcX+/DijWqLE2WjZOXWh 9XODEVG7jjLimQ2m6A3dCVHgBHuzdDhS6Rb8qe3bNHWt/M76kZoURpU5+b+vuxqMmEgzjzKCy 3+r4fP7MxT4M+HaMjFFmMvNTfSxIb4WFBIla9DcDu9L73Z4JiHIzghcOOzslbrHhXyLnoUc+U sZ+kqVBtvDyuu+TM6fKJPMc9QyA+8spujwseb8VdiA1wmA0KZThQRwReDB+drrr8zmZDfJesg L4PKUnY53C1j9ZRcIscIrNsUqBH3SC8RBsDi2Cc73KJ+WJgTez82CCF0k7KWLBYBcMQgCJEmq ilXeGqgW9XxPVd1IJEHyYPnshkIFprl9tvDFBt6mPNXtfkwGUJQ78kz31Q7ENgITBYrrixSaw lGWmZbQS8L28WdAqLseOnOcdwRweqNP1mjuHDMZu2hnqVj/vjz4cVsTPDJLB0qN2UncvP8SSz eaOU/fPakqT36xLQeByHnsAf41S8mjeO1KPmPAWGdjVvGIQ9/crf3vUgGOqpQQ1gIa++2Uy/W s5gCbiMfcP5rXJjlQRBMlnQ4+YlkGg7Qh4bZBLM3ADYtmQXqx1aT7MxhX9UaWqaAIanM/uk6d spT+a8BWxt6E4YSS+Xn/YJV3I8b2Hho6fsDqvUXWGPKyiebJxagX0kle8GoJvaRhI63Nz/1yP CAuWvjH8kBUhGKEDzdfrxLlGoZg+nH3DPvz5dqELvMI2N+FbiOQbcgI5KZvrxSSR4Kl2BFrV8 6BdmqwYA6Nu0zFKr/d8+jIqSVdj+5dLLCDKvKiuG+yjO1QjtkmLM3qGwwoDm8PxJdGiJ42gKs Mqpln8eKDkpzgsD3l/oi7MF6aKP7WBREN9ukiwg25aoRXMPpgN3j5Z/zp List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Laurenz Albe schrieb am 15.07.2026 um 23:20: >> =C2=A0=C2=A0=C2=A04. Most business apps use REPEATABLE READ as an indus= try standard. >=20 > I am surprised by that statement. >=20 > My experience is that most developers of "business apps" aren't even awa= re that there > are different transaction isolation levels. I think, this viewpoint might be based on the fact that it's the default i= solation level in MySQL/MariaDB=20 and due to their "marked share", it might be considered a an "industry sta= ndard" by a lot of people.=20