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 1lqWpB-00059W-8W for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Jun 2021 08:11:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lqWpA-0004Jl-88 for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Jun 2021 08:11:00 +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 1lqWV0-0007mY-Gn for pgsql-bugs@lists.postgresql.org; Tue, 08 Jun 2021 07:50:10 +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 1lqWUv-0006qs-OJ for pgsql-bugs@lists.postgresql.org; Tue, 08 Jun 2021 07:50:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=LARRfHt+I+YCkKXGxIdw9KwCWpsnauc/uANZwrZNK/I=; b=Lvl/JAN9tOSZvkvAqvSJ7xA9kc /bjNsemFDXo3YaJHp5sOmL4ych5E5zS7bbGVeyiBT1VoXdTf6fi5j8SkOAyjoeean4kCJuYFjb5pq parc9WzNsAKtTb0sJr3TMcMpUxKon29MOxOecN00tNRRMFkxSqAYgdULQAB2dL9jAtOpI9XjupBAY gRhAx4Ryh86Lc47ZuV8Ko2ybMtJclMARFfkQouO/7UqhqepMVwYsQu+lZKZX7JQyiE0EmHIf73Ku0 LOlK7urg4JAavrxYQeHlNDL/nowRfNZpwbNwJasRF1xPPmPtO/w8eMq5QzxhRjIwRUzwEFc1isQNn Q6tbdodw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lqWUv-0004y9-2b for pgsql-bugs@lists.postgresql.org; Tue, 08 Jun 2021 07:50:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lqWUs-0007sM-A3 for pgsql-bugs@lists.postgresql.org; Tue, 08 Jun 2021 07:50:02 +0000 Content-Type: multipart/mixed; boundary="===============1693639952008537651==" MIME-Version: 1.0 Subject: BUG #17050: cursor with for update + commit in loop To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bulgakovalexey1980@gmail.com Reply-To: bulgakovalexey1980@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 08 Jun 2021 07:49:25 +0000 Message-ID: <17050-f77aa827dc85247c@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1693639952008537651== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA1MApMb2dnZWQgYnk6ICAgICAgICAgINCQ0LvQtdC60YHQtdC5INCR 0YPQu9Cz0LDQutC+0LIKRW1haWwgYWRkcmVzczogICAgICBidWxnYWtvdmFsZXhleTE5ODBAZ21h aWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIuNwpPcGVyYXRpbmcgc3lzdGVtOiAgIFJlZCBI YXQgNC40LjctMjMKRGVzY3JpcHRpb246ICAgICAgICAKCmNyZWF0ZSB0YWJsZSBwdWJsaWMudGVz dF90dXBsZV9zdHJlYW0gKA0KCSAgIGlkIHNlcmlhbCwNCgkgICBubSB0ZXh0LA0KCSAgIGR0IHRp bWVzdGFtcHR6LA0KCSAgIG51bSBiaWdpbnQNCgkgICApOw0KDQpDUkVBVEUgT1IgUkVQTEFDRSBQ Uk9DRURVUkUgcHVibGljLnRlc3RfdHVwbGVfc3RyZWFtKCkNCiBMQU5HVUFHRSBwbHBnc3FsDQpB UyAkcHJvY2VkdXJlJA0KICBkZWNsYXJlDQoJICBsX2N1ciBjdXJzb3IgZm9yDQoJICAgIHNlbGVj dCBpZA0KCSAgICBmcm9tIHB1YmxpYy50ZXN0X3R1cGxlX3N0cmVhbQ0KCSAgICBvcmRlciBieSBp ZA0KCSAgICBmb3IgdXBkYXRlOw0KCWJlZ2luDQoJICBmb3IgcmVjIGluIGxfY3VyIGxvb3ANCgkg ICAgdXBkYXRlIHB1YmxpYy50ZXN0X3R1cGxlX3N0cmVhbQ0KCSAgICBzZXQgbnVtID0gbnVtICsg MQ0KCSAgICB3aGVyZSBpZCA9IHJlYy5pZDsNCgkgICANCgkgICAgY29tbWl0OwkgICANCgkgIGVu ZCBsb29wOw0KCSANCgkgIGNvbW1pdDsNCglFTkQ7DQokcHJvYwkgIA0KCSAgDQotLQl0cnVuY2F0 ZSB0YWJsZSBwdWJsaWMudGVzdF90dXBsZV9zdHJlYW07ICANCgkgIA0KCWluc2VydCBpbnRvIHB1 YmxpYy50ZXN0X3R1cGxlX3N0cmVhbShubSwgZHQsIG51bSkNCgl2YWx1ZXMgKCdBJywgbm93KCks IDEpOw0KCWluc2VydCBpbnRvIHB1YmxpYy50ZXN0X3R1cGxlX3N0cmVhbShubSwgZHQsIG51bSkN Cgl2YWx1ZXMgKCdCJywgbm93KCksIDEpOw0KCWluc2VydCBpbnRvIHB1YmxpYy50ZXN0X3R1cGxl X3N0cmVhbShubSwgZHQsIG51bSkNCgl2YWx1ZXMgKCdDJywgbm93KCksIDEpOw0KDQogIGNhbGwg cHVibGljLnRlc3RfdHVwbGVfc3RyZWFtKCkNCg0KCXNlbGVjdCAqDQoJZnJvbSBwdWJsaWMudGVz dF90dXBsZV9zdHJlYW0NCglvcmRlciBieSBpZA0KDQpJZiBydW4gcHJvY2VkdXJlIHRlc3RfdHVw bGVfc3RyZWFtIHRoZW4gaW4gcmVzdWx0IHVwZGF0ZWQgMiByb3dzIG9mIDMuCldoeT8NCmlmIHJl bW92ZSBpbiBwcm9jZWR1cmUgImZvciB1cGRhdGUiIG9yICJjb21taXQgaW4gbG9vcCIgdGhlbiB1 cGRhdGVkIDMgcm93cwpvZiAzCgo= --===============1693639952008537651==--