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.94.2) (envelope-from ) id 1rotmJ-003yhM-Au for pgsql-committers@arkaria.postgresql.org; Mon, 25 Mar 2024 23:30:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rotmH-009BXn-VM for pgsql-committers@arkaria.postgresql.org; Mon, 25 Mar 2024 23:30:54 +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.94.2) (envelope-from ) id 1rotmH-009BX5-Mv for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 23:30:54 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rotmD-006UBL-LB for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 23:30:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=BJqCfiV8KBnEIUTiPQCUihccP5kY+nNEpuaVGbjZG14=; b=h4d5uxo6nwjn/bdJnOxPwmZo34 PWN83DXPA2nNPXoshT+QIPsZsylvD4TQO5MZcg1Se59BV9XjDOghjZuteBeQRAaV+64bI7GQPCFxu 5QT3kG2MQA4qzWXgMPVRTmM4d7jTInlAYSNdRzSMjc0i9REX2raNVL7C78dbU9zVa62nACzQJXAbQ mXlc7qg10QBnwqdcHy5sHbwX9C6/F20o7VgNpLK2fRAtP1mq9MceGmtos854sHv8DVz/hdUq9i91B D0gaDd27raY7OqWIT0Br0nSB9SOKHwBJ8k7+5gZ0SfKmi6OXV8yjvNuF/zChzEM6L+/lqF/PUjs68 bvxnyz1w==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rotmC-000Gp7-E0 for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 23:30:48 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rotmB-005eXB-Fn for pgsql-committers@lists.postgresql.org; Mon, 25 Mar 2024 23:30:47 +0000 Content-Type: multipart/mixed; boundary="===============0260872384803659071==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow locking updated tuples in tuple_update() and tuple_delete( X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 25 Mar 2024 23:30:47 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0260872384803659071== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgbG9ja2luZyB1cGRhdGVkIHR1cGxlcyBpbiB0dXBsZV91cGRhdGUoKSBhbmQgdHVwbGVf ZGVsZXRlKCkKCkN1cnJlbnRseSwgaW4gcmVhZCBjb21taXR0ZWQgdHJhbnNhY3Rpb24gaXNvbGF0 aW9uIG1vZGUgKGRlZmF1bHQpLCB3ZSBoYXZlIHRoZQpmb2xsb3dpbmcgc2VxdWVuY2Ugb2YgYWN0 aW9ucyB3aGVuIHR1cGxlX3VwZGF0ZSgpL3R1cGxlX2RlbGV0ZSgpIGZpbmRzCnRoZSB0dXBsZSB1 cGRhdGVkIGJ5IHRoZSBjb25jdXJyZW50IHRyYW5zYWN0aW9uLgoKMS4gQXR0ZW1wdCB0byB1cGRh dGUvZGVsZXRlIHR1cGxlIHdpdGggdHVwbGVfdXBkYXRlKCkvdHVwbGVfZGVsZXRlKCksIHdoaWNo CiAgIHJldHVybnMgVE1fVXBkYXRlZC4KMi4gTG9jayB0dXBsZSB3aXRoIHR1cGxlX2xvY2soKS4K My4gUmUtZXZhbHVhdGUgcGxhbiBxdWFsIChyZWNoZWNrIGlmIHdlIHN0aWxsIG5lZWQgdG8gdXBk YXRlL2RlbGV0ZSBhbmQKICAgY2FsY3VsYXRlIHRoZSBuZXcgdHVwbGUgZm9yIHVwZGF0ZSkuCjQu IFNlY29uZCBhdHRlbXB0IHRvIHVwZGF0ZS9kZWxldGUgdHVwbGUgd2l0aCB0dXBsZV91cGRhdGUo KS90dXBsZV9kZWxldGUoKS4KICAgVGhpcyBhdHRlbXB0IHNob3VsZCBiZSBzdWNjZXNzZnVsLCBz aW5jZSB0aGUgdHVwbGUgd2FzIHByZXZpb3VzbHkgbG9ja2VkLgoKVGhpcyBjb21taXQgZWxpbWlu YXRlcyBzdGVwIDIgYnkgdGFraW5nIHRoZSBsb2NrIGR1cmluZyB0aGUgZmlyc3QKdHVwbGVfdXBk YXRlKCkvdHVwbGVfZGVsZXRlKCkgY2FsbC4gIFRoZSBoZWFwIHRhYmxlIGFjY2VzcyBtZXRob2Qg c2F2ZXMgc29tZQplZmZvcnQgYnkgY2hlY2tpbmcgdGhlIHVwZGF0ZWQgdHVwbGUgb25jZSBpbnN0 ZWFkIG9mIHR3aWNlLiAgRnV0dXJlCnVuZG8tYmFzZWQgdGFibGUgYWNjZXNzIG1ldGhvZHMsIHdo aWNoIHdpbGwgc3RhcnQgZnJvbSB0aGUgbGF0ZXN0IHJvdyB2ZXJzaW9uLApjYW4gaW1tZWRpYXRl bHkgcGxhY2UgYSBsb2NrIHRoZXJlLgoKQWxzbywgdGhpcyBjb21taXQgbWFrZXMgdHVwbGVfdXBk YXRlKCkvdHVwbGVfZGVsZXRlKCkgb3B0aW9uYWxseSBzYXZlIHRoZSBvbGQKdHVwbGUgaW50byB0 aGUgZGVkaWNhdGVkIHNsb3QuICBUaGF0IHNhdmVzIGVmZm9ydHMgb24gcmUtZmV0Y2hpbmcgdHVw bGVzIGluCmNlcnRhaW4gY2FzZXMuCgpUaGUgY29kZSBpbiBub2RlTW9kaWZ5VGFibGUuYyBpcyBz aW1wbGlmaWVkIGJ5IHJlbW92aW5nIHRoZSBuZXN0ZWQgc3dpdGNoL2Nhc2UuCgpEaXNjdXNzaW9u OiBodHRwczovL3Bvc3Rnci5lcy9tL0NBUHBIZmR1YS1ZRnczWFRwcmZ1dHpHcDI4eFhMaWdGdHpO YnVGWTh5UGhxZXE2WDVrZyU0MG1haWwuZ21haWwuY29tClJldmlld2VkLWJ5OiBBbGVrc2FuZGVy IEFsZWtzZWV2LCBQYXZlbCBCb3Jpc292LCBWaWduZXNoIEMsIE1hc29uIFNoYXJwClJldmlld2Vk LWJ5OiBBbmRyZXMgRnJldW5kLCBDaHJpcyBUcmF2ZXJzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv ODc5ODVjYzkyNTIyOTZmMTFkYjNjYWNjMTU1ZThkNzEwZDJlOWI5YwoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvaGVhcGFtLmMgICAgICAgICB8 IDIwNSArKysrKysrKysrKysrLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvaGVhcGFtX2hh bmRsZXIuYyB8ICA5NCArKysrKystLQpzcmMvYmFja2VuZC9hY2Nlc3MvdGFibGUvdGFibGVhbS5j ICAgICAgIHwgIDI2ICsrLQpzcmMvYmFja2VuZC9jb21tYW5kcy90cmlnZ2VyLmMgICAgICAgICAg IHwgIDU1ICsrLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNSZXBsaWNhdGlvbi5jICAgfCAg MTkgKy0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZU1vZGlmeVRhYmxlLmMgICB8IDM1MyArKysr KysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL2FjY2Vzcy9oZWFwYW0uaCAg ICAgICAgICAgICAgfCAgMTkgKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL3RhYmxlYW0uaCAgICAgICAg ICAgICB8ICA3MyArKysrKy0tCnNyYy9pbmNsdWRlL2NvbW1hbmRzL3RyaWdnZXIuaCAgICAgICAg ICAgfCAgIDQgKy0KOSBmaWxlcyBjaGFuZ2VkLCA1MDIgaW5zZXJ0aW9ucygrKSwgMzQ2IGRlbGV0 aW9ucygtKQoK --===============0260872384803659071==--