Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf5zX-0005F3-Fi for pgsql-committers@arkaria.postgresql.org; Wed, 22 Mar 2023 21:27:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pf5zV-0001Zr-UV for pgsql-committers@arkaria.postgresql.org; Wed, 22 Mar 2023 21:27:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf5zV-0001ZQ-Kz for pgsql-committers@lists.postgresql.org; Wed, 22 Mar 2023 21:27:29 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf5zS-0007Cw-Nd for pgsql-committers@lists.postgresql.org; Wed, 22 Mar 2023 21:27:28 +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=wy9JpDHyLWLjnnBDD3M7G/VWPVyLn4KQypUTxWo1hoE=; b=qwqdI93Nhd0xVJt+egcudYEjj4 DKYJuhndm4zBSgC0U65T0ZLQ+DXqydYZhuB6yJrHGtNzVKMY5BlmeNI90UzKa8CG5vKTdZjmiuq5Z V29A2K46yTu1FeaJeFyXXe3lqbpgeSD2AQ7YTsCW2tecDZ421qJq6bHaXVMuZNQUJ68D2BYMq4k5P qwmUhZDIUQwrsUBCrlbFxW4rcf3f5FechARveMfWt82Hc5QDQDxUUGW1Jy1Mq14mdEVxZmmBV6BYD 8jFVSbymCyTlk9/uLTlxN+atzFO0WS3SkVrR99XfxdUkkySTV4/0IyqxqZlUftxb/Wb77yYQOJW6m P5hLSSUQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf5zS-0007gT-4u for pgsql-committers@lists.postgresql.org; Wed, 22 Mar 2023 21:27:26 +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 1pf5zQ-004tAk-TI for pgsql-committers@lists.postgresql.org; Wed, 22 Mar 2023 21:27:25 +0000 Content-Type: multipart/mixed; boundary="===============7138958250697009164==" 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: Wed, 22 Mar 2023 21:27:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7138958250697009164== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgbG9ja2luZyB1cGRhdGVkIHR1cGxlcyBpbiB0dXBsZV91cGRhdGUoKSBhbmQgdHVwbGVf ZGVsZXRlKCkKCkN1cnJlbnRseSwgaW4gcmVhZCBjb21taXR0ZWQgdHJhbnNhY3Rpb24gaXNvbGF0 aW9uIG1vZGUgKGRlZmF1bHQpLCB3ZSBoYXZlIHRoZQpmb2xsb3dpbmcgc2VxdWVuY2Ugb2YgYWN0 aW9ucyB3aGVuIHR1cGxlX3VwZGF0ZSgpL3R1cGxlX2RlbGV0ZSgpIGZpbmRzCnRoZSB0dXBsZSB1 cGRhdGVkIGJ5IGNvbmN1cnJlbnQgdHJhbnNhY3Rpb24uCgoxLiBBdHRlbXB0IHRvIHVwZGF0ZS9k ZWxldGUgdHVwbGUgd2l0aCB0dXBsZV91cGRhdGUoKS90dXBsZV9kZWxldGUoKSwgd2hpY2gKICAg cmV0dXJucyBUTV9VcGRhdGVkLgoyLiBMb2NrIHR1cGxlIHdpdGggdHVwbGVfbG9jaygpLgozLiBS ZS1ldmFsdWF0ZSBwbGFuIHF1YWwgKHJlY2hlY2sgaWYgd2Ugc3RpbGwgbmVlZCB0byB1cGRhdGUv ZGVsZXRlIGFuZAogICBjYWxjdWxhdGUgdGhlIG5ldyB0dXBsZSBmb3IgdXBkYXRlKS4KNC4gU2Vj b25kIGF0dGVtcHQgdG8gdXBkYXRlL2RlbGV0ZSB0dXBsZSB3aXRoIHR1cGxlX3VwZGF0ZSgpL3R1 cGxlX2RlbGV0ZSgpLgogICBUaGlzIGF0dGVtcHQgc2hvdWxkIGJlIHN1Y2Nlc3NmdWwsIHNpbmNl IHRoZSB0dXBsZSB3YXMgcHJldmlvdXNseSBsb2NrZWQuCgpUaGlzIHBhdGNoIGVsaW1pbmF0ZXMg c3RlcCAyIGJ5IHRha2luZyB0aGUgbG9jayBkdXJpbmcgZmlyc3QKdHVwbGVfdXBkYXRlKCkvdHVw bGVfZGVsZXRlKCkgY2FsbC4gIEhlYXAgdGFibGUgYWNjZXNzIG1ldGhvZCBzYXZlcyBzb21lCmVm Zm9ydHMgYnkgY2hlY2tpbmcgdGhlIHVwZGF0ZWQgdHVwbGUgb25jZSBpbnN0ZWFkIG9mIHR3aWNl LiAgRnV0dXJlCnVuZG8tYmFzZWQgdGFibGUgYWNjZXNzIG1ldGhvZHMsIHdoaWNoIHdpbGwgc3Rh cnQgZnJvbSB0aGUgbGF0ZXN0IHJvdyB2ZXJzaW9uLApjYW4gaW1tZWRpYXRlbHkgcGxhY2UgYSBs b2NrIHRoZXJlLgoKVGhlIGNvZGUgaW4gbm9kZU1vZGlmeVRhYmxlLmMgaXMgc2ltcGxpZmllZCBi eSByZW1vdmluZyB0aGUgbmVzdGVkIHN3aXRjaC9jYXNlLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9w b3N0Z3IuZXMvbS9DQVBwSGZkdWEtWUZ3M1hUcHJmdXR6R3AyOHhYTGlnRnR6TmJ1Rlk4eVBocWVx Nlg1a2clNDBtYWlsLmdtYWlsLmNvbQpSZXZpZXdlZC1ieTogQWxla3NhbmRlciBBbGVrc2Vldiwg UGF2ZWwgQm9yaXNvdiwgVmlnbmVzaCBDLCBNYXNvbiBTaGFycApSZXZpZXdlZC1ieTogQW5kcmVz IEZyZXVuZCwgQ2hyaXMgVHJhdmVycwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzExNDcwZjU0NGUz NzI5YzYwZmFiODkwMTQ1YjJlODM5Y2JjODkwNWUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL2hlYXBhbV9oYW5kbGVyLmMgfCAxMDkgKysrKysr KysrKystCnNyYy9iYWNrZW5kL2FjY2Vzcy90YWJsZS90YWJsZWFtLmMgICAgICAgfCAgIDYgKy0K c3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZU1vZGlmeVRhYmxlLmMgICB8IDI4OCArKysrKysrKysr KysrLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL2FjY2Vzcy90YWJsZWFtLmggICAgICAg ICAgICAgfCAgMjggKystCnNyYy9pbmNsdWRlL2V4ZWN1dG9yL3R1cHRhYmxlLmggICAgICAgICAg fCAgMzggKysrKwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgIHwgICAy ICsKNiBmaWxlcyBjaGFuZ2VkLCAyODUgaW5zZXJ0aW9ucygrKSwgMTg2IGRlbGV0aW9ucygtKQoK --===============7138958250697009164==--