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 1rmbvw-008u2T-S6 for pgsql-general@arkaria.postgresql.org; Tue, 19 Mar 2024 16:03:25 +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 1rmbvv-00Gbdi-A8 for pgsql-general@arkaria.postgresql.org; Tue, 19 Mar 2024 16:03:23 +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 1rmbvu-00Gbda-UK for pgsql-general@lists.postgresql.org; Tue, 19 Mar 2024 16:03:23 +0000 Received: from fhigh8-smtp.messagingengine.com ([103.168.172.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rmbvq-005ORC-Lu for pgsql-general@lists.postgresql.org; Tue, 19 Mar 2024 16:03:22 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 60B92114006D; Tue, 19 Mar 2024 12:03:17 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Tue, 19 Mar 2024 12:03:17 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1710864197; x=1710950597; bh=iSaDKvN8qZXuGVmzgvyHt5OmzO45hXEMTi5RzMW4eSI=; b= hkE73772uKFKbcB+kiMlejyBYlWL/Aqm5ICtA9OL5hVGPxMqGy8z0OEcxxOq4iee Q45GjznxkMEqUmuyyL0CiobBLFAWCDp3BQ0CpC6HTJskWnBXMtl1N4WJQ36kVlOF WitKs2p4qbIHRNdQJBZjFqXx/mdt+Ct4HYIFYMaA/FeOFq12mUqD8egdFqiH9I36 jGeP+JmHK7a3tiusNj7EAbwAK8C4PbvYuPaIw4p1RqLPkV8j54086DYCxH2NNJk3 pWAZkDk98n7ckC2k+7ApJOKxGVlefPrAYRhOJzT06CtTc9W00VFFI5eLGQ8HxdhV Jcpu77hZyb0XHpB3BZHdIA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1710864197; x= 1710950597; bh=iSaDKvN8qZXuGVmzgvyHt5OmzO45hXEMTi5RzMW4eSI=; b=N lgJyG8X5Q8CroWs4BE2FCOopPxO54jEf147JeAjqPk2RB46SdkXpDfMWNc0fvqL1 diXWz6v9+6LlKDBkXNjcwPpgRl+n+az8rF5RQtAYRcQLihHIeWw0a+nluy5F48tO 427cKS94Su+nqkBFAaSXkf+ZyIeBuyDLMJoCziX3Cb3m5jwNdwip1LRAWw0c18JQ 6ewcBG+PoJCsjGuE3C6oNRblFvw2mpGTq3SLmL0Gm/fkD2LfcILrpSdSqtBFlydA I/kcu4ca4dzQk6Wkc5npeguhW4Wn7vZQcq1zy3QebaMd0+/MG5s+fIyQo9xmskAo deNZibl4ADbeIyF8y4BBQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrledtgdehjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthgsredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeffvdehkeektddufefhjeehgfdtfeevleehveffvdei udeuudejgfffieduudfgieenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 19 Mar 2024 12:03:16 -0400 (EDT) Message-ID: Date: Tue, 19 Mar 2024 09:03:15 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Query on Postgres SQL transaction Content-Language: en-US To: "Bandi, Venkataramana - Dell Team" , Greg Sabino Mullane Cc: "pgsql-general@lists.postgresql.org" , "Kishore, Nanda - Dell Team" , "Alampalli, Kishore" References: From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMy8xOS8yNCAwMjoxOCwgQmFuZGksIFZlbmthdGFyYW1hbmEgLSBEZWxsIFRlYW0gd3Jv dGU6DQo+IEhpIEdyZWcsDQo+IA0KPiBXZSBhcmUgdXNpbmcgaGliZXJuYXRlIGZyYW1ld29y ayB0byBwZXJzaXN0IHRoZSBkYXRhIGludG8gUG9zdGdyZXMgU1FMIA0KPiBEQiBhbmQgZGF0 YSBpcyBwZXJzaXN0aW5nIGFuZCBjb21taXR0aW5nIGZvciBhbGwgdGhlIGNsaWVudHMgYnV0 IG9uZSBvZiANCj4gdGhlIGNsaWVudCBkYXRhIGlzIG5vdCBpbnNlcnRlZCBpbnRvIERCLg0K DQpXaGF0IGlzIGRpZmZlcmVudCBhYm91dCB0aGF0IGNsaWVudD8NCg0KQXJlIGFsbCB0aGUg Y2xpZW50cyBwYXNzaW5nIGRhdGEgdGhyb3VnaCB0aGUgc2FtZSBpbnN0YW5jZSBvZiB0aGUg ZnJhbWV3b3JrPw0KDQpBcmUgeW91IHN1cmUgdGhhdCB0aGUgY2xpZW50IGlzIHBvaW50ZWQg YXQgdGhlIGNvcnJlY3QgZGF0YWJhc2U/DQoNCklzIHRoZSBsb2cgZW50cnkgYmVsb3cgZnJv bSB0aGF0IGNsaWVudD8NCg0KPiANCj4gTm90IGdldHRpbmcgYW55IGVycm9yL2V4Y2VwdGlv biBmb3IgdGhpcyBjYXNlLiBDb3VsZCB5b3UgcGxlYXNlIGxldCB1cyANCj4ga25vdyBob3cg d2UgY2FuIHRyYWNlIG91dCB0aGlzIHNjZW5hcmlvIG9uIHRyYW5zYWN0aW9uIGxldmVsIHdo ZXRoZXIgDQo+IHRyYW5zYWN0aW9uIGlzIGNvbW1pdHRpbmcgb3Igbm90Pw0KPiANCj4gV2Ug aGF2ZSBlbmFibGVkIGJlbG93IHByb3BlcnRpZXMgaW4gcG9zdGdyZXNxbC5jb25mIGZpbGUg YW5kIHZlcmlmaWVkIA0KPiBidXQgZGlkbid0IGdldCBhbnkgZmluZGluZ3MgYWJvdXQgdGhl IHRyYW5zYWN0aW9uIGFuZCBiZWxvdyBsb2cgDQo+IHN0YXRlbWVudHMgYXJlIHdyaXRpbmcg aW4gb3VyIGRhdGEgc3RvcmUgbG9ncy4NCj4gDQo+IGxvZ19zdGF0ZW1lbnQgPSAnYWxsJw0K PiANCj4gbG9nZ2luZ19jb2xsZWN0b3IgPSBvbg0KPiANCj4gbG9nX21pbl9tZXNzYWdlcyA9 IGRlYnVnNQ0KPiANCj4gbG9nX21pbl9lcnJvcl9zdGF0ZW1lbnQgPSBkZWJ1ZzUNCj4gDQo+ IDIwMjQtMDItMTkgMTU6MjE6NTQuODUwICswOCBbMTg3Nl0gTE9HOsKgIGV4ZWN1dGUgU180 ODogaW5zZXJ0IGludG8gDQo+IHh4eHh4eHggDQo+IChmX3NjaGVkdWxlX25hbWUsZl9pZCxm X3RvdGFsZGF0YXJlZHRuLGZfaW52YWxpZGF0aW9udGltZSxmX3N0YXR1c2NvZGUsZl9tb2R1 bGUsZl9hcHBfdHlwZSxmX2RiYmFja3VwdHlwZSxmX2lzX2NvbXByZXNzZWQsZl9wcm94eSxm X3NpemUsZl9zaXplcHJvdGVjdGVkLGZfZ3JvdXBqb2JpZCxmX3N0YXR1cyxmX2J5dGVzbW9k aWZpZWRub3RzZW50LGZfc2l6ZXRyYW5zZmVycmVkYm9mZnNldCxmX2J5dGVzbW9kaWZpZWRz ZW50LGZfZXJyY29kZSxmX2pvYmlkMixmX21lZGlhX3NlcnZlcixmX3N0YXJ0dGltZSxmX3N0 b3JhZ2VpZCxmX3Bvb2wsZl9xdWV1ZXN0YXJ0LGZfc2l6ZXNjYW5uZWRib2Zmc2V0LGZfZXJy b3Jjb2Rlc3VtbWFyeSxmX25jb3BpZXMsZl9zaXplcHJvdGVjdGVkYm9mZnNldCxmX3NuYXBf dGFyZ2V0X3BsYXRmb3JtLGZfYmFja3VwX3NlcnZlcm5hbWUsZl9uZmlsZXMsZl9leHBpcnks Zl9vd25lcixmX3BvbGljeV9pZCxmX3BhcmVudGpvYmlkLGZfc3ViX25hbWUsZl9jb21wbGV0 aW9uX3N0YXR1cyxmX2VuZHRpbWUsZl9maWxlc3NjYW5uZWQsZl9pZGxlX3dhaXQsZl9zdG9y YWdlX3VuaXQsZl9ncm91cF9pZCxmX2JhY2t1cF9zZXQsZl9udHJpZXMsZl9qb2JfbmFtZSxm X2xldmVsLGZfYWdlbnRfbmFtZSxmX2ZhaWxlZF9jb3BpZXMsZl9yZXN0YXJ0ZWRfam9iLGZf c3VjY2Vzc19jb3BpZXMsZl9kb21haW5faWQsZl9zbmFwX3RhcmdldCxmX2pvYmlkLGZfcmVx dWVzdF9pZCxmX3BsdWdpbm5hbWUsZl9zaXpldHJhbnNmZXJyZWQsZl9pc19zbmFwLGZfbm9k ZV9pZCxmX3dvcmtmbG93X2lkLGZfYWN0aW9uX25hbWUsZl9hZ2VudF9pZCxmX2luc3RhbmNl bmFtZSxmX3Nlc3Npb24sZl90b3RhbG9iamRlZHVwLGZfY2hhbmdlZGJ5dGVzLGZfc2l6ZWJv ZmZzZXQsZl9kZWR1cHJlZHRuLGZfc3RhdHVzY29kZXN1bW1hcnksZl93b3JrZmxvd19qb2Jp ZCxmX3NuYXBfcG9saWN5LGZfc2l6ZV9jb3BpZXMsZl9zaXplc2Nhbm5lZCxmX3N1Yl9pZCxm X2FyY2hpdmVfZmxhZyxmX25maWxlc25vdCxmX21lZGlhX3dhaXQsZl9zbmFwX2NyZWF0aW9u LGZfZWZmZWN0aXZlX3BhdGgpIHZhbHVlcyAoJDEsJDIsJDMsJDQsJDUsJDYsJDcsJDgsJDks JDEwLCQxMSwkMTIsJDEzLCQxNCwkMTUsJDE2LCQxNywkMTgsJDE5LCQyMCwkMjEsJDIyLCQy MywkMjQsJDI1LCQyNiwkMjcsJDI4LCQyOSwkMzAsJDMxLCQzMiwkMzMsJDM0LCQzNSwkMzYs JDM3LCQzOCwkMzksJDQwLCQ0MSwkNDIsJDQzLCQ0NCwkNDUsJDQ2LCQ0NywkNDgsJDQ5LCQ1 MCwkNTEsJDUyLCQ1MywkNTQsJDU1LCQ1NiwkNTcsJDU4LCQ1OSwkNjAsJDYxLCQ2MiwkNjMs JDY0LCQ2NSwkNjYsJDY3LCQ2OCwkNjksJDcwLCQ3MSwkNzIsJDczLCQ3NCwkNzUsJDc2LCQ3 NywkNzgpDQo+IA0KPiAyMDI0LTAyLTE5IDE1OjIxOjU0Ljg1MSArMDggWzEwOTI4XSBERUJV RzrCoCBiaW5kIDx1bm5hbWVkPiB0byA8dW5uYW1lZD4NCj4gDQo+IDIwMjQtMDItMTkgMTU6 MjE6NTQuODUyICswOCBbMTA5MjhdIERFQlVHOsKgIENvbW1pdFRyYW5zYWN0aW9uKDEpIG5h bWU6IA0KPiB1bm5hbWVkOyBibG9ja1N0YXRlOiBTVEFSVEVEOyBzdGF0ZTogSU5QUk9HUkVT UywgeGlkL3N1YmlkL2NpZDogMC8xLzANCj4gDQo+IFJlZ2FyZHMsDQo+IA0KPiBWZW5rYXQN Cj4gDQo+ICoNCj4gKg0KPiANCj4gKg0KPiANCj4gSW50ZXJuYWwgVXNlIC0gQ29uZmlkZW50 aWFsDQo+IA0KPiBGcm9tOipHcmVnIFNhYmlubyBNdWxsYW5lIDxodGFtZmlkc0BnbWFpbC5j b20+DQo+ICpTZW50OiogU2F0dXJkYXksIE1hcmNoIDE2LCAyMDI0IDEyOjA3IEFNDQo+ICpU bzoqIEJhbmRpLCBWZW5rYXRhcmFtYW5hIC0gRGVsbCBUZWFtIDxWZW5rYXRhcmFtYW5hLkJh bmRpQGRlbGx0ZWFtLmNvbT4NCj4gKkNjOiogcGdzcWwtZ2VuZXJhbEBsaXN0cy5wb3N0Z3Jl c3FsLm9yZzsgS2lzaG9yZSwgTmFuZGEgLSBEZWxsIFRlYW0gDQo+IDxOYW5kYS5LaXNob3Jl QERlbGx0ZWFtLmNvbT47IEFsYW1wYWxsaSwgS2lzaG9yZSANCj4gPEtpc2hvcmVyYXZpc2hh bmthci5BbGFtcGFsbGlAZGVsbHRlYW0uY29tPg0KPiAqU3ViamVjdDoqIFJlOiBRdWVyeSBv biBQb3N0Z3JlcyBTUUwgdHJhbnNhY3Rpb24NCj4gDQo+IFtFWFRFUk5BTCBFTUFJTF0NCj4g DQo+IFRoYXQncyBhIHZlcnkgdmFndWUgcXVlc3Rpb24sIGJ1dCB5b3UgY2FuIHRyYWNlIGV4 YWN0bHkgd2hhdCBpcyANCj4gaGFwcGVuaW5nIGJ5IGlzc3VpbmcNCj4gDQo+IFNFVCBsb2df c3RhdGVtZW50ID0gJ2FsbCc7DQo+IA0KPiBJZGVhbGx5IGF0IHRoZSBzZXNzaW9uIGxldmVs IGJ5IHlvdXIgYXBwbGljYXRpb24sIGJ1dCBjYW4gYWxzbyBzZXQgaXQgYXQgDQo+IHRoZSBk YXRhYmFzZSBhbmQgdXNlciBsZXZlbC4gSWYgYWxsIGVsc2UgZmFpbHMsIHNldCBpdCBnbG9i YWxseSAoaS5lLiANCj4gcG9zdGdyZXNxbC5jb25mKS4gVHVybiBpdCBvZmYgYWdhaW4gYXMg c29vbiBhcyBwb3NzaWJsZSwgaXQgd2lsbCBtYWtlIA0KPiB5b3VyIGxvZ3MgZXh0cmVtZWx5 IHZlcmJvc2UuIEJ1dCB5b3UgY2FuIHRyYWNrIGV4YWN0bHkgd2hhdCB5b3VyIA0KPiBhcHBs aWNhdGlvbiBpcyBkb2luZy4NCj4gDQo+IENoZWVycywNCj4gDQo+IEdyZWcNCj4gDQoNCi0t IA0KQWRyaWFuIEtsYXZlcg0KYWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbQ0KDQo=