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 1vIQwo-000jxj-2O for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 12:24:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIQwm-000HfE-1f for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 12:24:36 +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.94.2) (envelope-from ) id 1vIPQS-00Fwte-24 for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 10:47:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIPQQ-006MMJ-0h for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 10:47:07 +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=ozWyQt34qUzMBM2ltJ3yrViKDsrgwynPJl0TFDkJdGA=; b=KWXfAgtI8QTUrc8qDKagIpsjQG o3Hp7I/utLjEfJCJ1n+Z00tFAsFzWOlYepoUSb3r1A88AzpFv1+9Jvw+nkl4ZVbwbWqfa2WAdNVSk UusQ90sybCLMsz8sdRb6lSyqMdhB5snIJ74OCoMoMqMaz1ARi4AsMRzNVVqOC+6vYlmXDcHs71U+j Jp6DbNiuidHukcxZyMuNaeezAGw2+djVn2Be0Zzu1yz5rMefO3p8/M/2ROAnRSc8CwPXsdL3VsUSZ 8wQWJ7OruWcobL8u2s8isiTXvAPzrJmwfJZF22Vz25x73IcjzoqyJ+enkCUFLD+5Z1fJTL7jNxQ1y Im2/SBkg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vIPQO-00CX73-F9 for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 10:47:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIPQM-004sZH-2F for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 10:47:03 +0000 Content-Type: multipart/mixed; boundary="===============7867463790277145421==" MIME-Version: 1.0 Subject: BUG #19107: The hold cursor is unexpectedly released during rollback To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zengman@halodbtech.com Reply-To: zengman@halodbtech.com, pgsql-bugs@lists.postgresql.org Date: Mon, 10 Nov 2025 10:46:44 +0000 Message-ID: <19107-656a10a7a066f7e9@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 --===============7867463790277145421== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTEwNwpMb2dnZWQgYnk6ICAgICAgICAgIE1hbiBaZW5nCkVtYWlsIGFk ZHJlc3M6ICAgICAgemVuZ21hbkBoYWxvZGJ0ZWNoLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE4 LjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjQuMDQKRGVzY3JpcHRpb246ICAgICAgICAK CkhpLCBoYWNrZXJzLgoKV2hpbGUgSSB3YXMgd3JpdGluZyB0ZXN0IGNhc2VzIGZvciB0aGUgaG9s ZCBjdXJzb3IsIEkgdW5leHBlY3RlZGx5CmRpc2NvdmVyZWQgdGhhdCBjb21taXQgYW5kIHJvbGxi YWNrIGhhbmRsZSBpdCBpbmNvbnNpc3RlbnRseeKAlHJvbGxiYWNrCnVuZXhwZWN0ZWRseSByZWxl YXNlcyB0aGUgaG9sZCBjdXJzb3IuIFNob3VsZCB0aGlzIGJlIHJlZ2FyZGVkIGFzIGEgYnVnPwoK LS0KUmVncmFkcywKTWFuIFplbmcKCnBvc3RncmVzPSMgLS0gb2sKcG9zdGdyZXM9IyBETyAkJApE RUNMQVJFCiAgdmFsIGludDsKQkVHSU4KICBGT1IgdmFsIElOIFNFTEVDVCBnZW5lcmF0ZV9zZXJp ZXMoMSwxMCkgTE9PUAogICAgcmFpc2Ugbm90aWNlICd2YWwgPSAlJywgdmFsOwogICAgSUYgdmFs ICUgMiA9IDAgVEhFTgogICAgICAgQ09NTUlUOwogICAgRUxTRQogICAgICAgUk9MTEJBQ0s7CiAg ICBFTkQgSUY7CiAgRU5EIExPT1A7CkVORDsgJCQ7Ck5PVElDRTogIHZhbCA9IDEKTk9USUNFOiAg dmFsID0gMgpOT1RJQ0U6ICB2YWwgPSAzCk5PVElDRTogIHZhbCA9IDQKTk9USUNFOiAgdmFsID0g NQpOT1RJQ0U6ICB2YWwgPSA2Ck5PVElDRTogIHZhbCA9IDcKTk9USUNFOiAgdmFsID0gOApOT1RJ Q0U6ICB2YWwgPSA5Ck5PVElDRTogIHZhbCA9IDEwCkRPCnBvc3RncmVzPSMKcG9zdGdyZXM9IyAt LSBob2xkX2N1cnNvciBjb21taXQgb2sKcG9zdGdyZXM9IyBkbyAkJApkZWNsYXJlCiAgcF9DdXJE YXRhIHJlZmN1cnNvciA6PSAnaG9sZF9jdXJzb3InOwogIHZhbCBpbnQ7CmJlZ2luCiAgZXhlY3V0 ZSAnZGVjbGFyZSBob2xkX2N1cnNvciBDVVJTT1IgV0lUSCBIT0xEIEZPUiBTRUxFQ1QgNDInOwog IGxvb3AKICAgIGZldGNoIHBfQ3VyRGF0YSBpbnRvIHZhbDsKICAgIGV4aXQgd2hlbiB2YWwgaXMg bnVsbDsKICAgIHJhaXNlIG5vdGljZSAndmFsID0gJScsIHZhbDsKICAgIGNvbW1pdDsKICBlbmQg bG9vcDsKICBjbG9zZSBwX0N1ckRhdGE7CmVuZDsgJCQ7Ck5PVElDRTogIHZhbCA9IDQyCkRPCnBv c3RncmVzPSMKcG9zdGdyZXM9IyAtLSBob2xkX2N1cnNvciByb2xsYmFjayBlcnJvcgpwb3N0Z3Jl cz0jIGRvICQkCmRlY2xhcmUKICBwX0N1ckRhdGEgcmVmY3Vyc29yIDo9ICdob2xkX2N1cnNvcic7 CiAgdmFsIGludDsKYmVnaW4KICBleGVjdXRlICdERUNMQVJFIGhvbGRfY3Vyc29yIENVUlNPUiBX SVRIIEhPTEQgRk9SIFNFTEVDVCA0Mic7CiAgbG9vcAogICAgZmV0Y2ggcF9DdXJEYXRhIGludG8g dmFsOwogICAgZXhpdCB3aGVuIHZhbCBpcyBudWxsOwogICAgcmFpc2Ugbm90aWNlICd2YWwgPSAl JywgdmFsOwogICAgcm9sbGJhY2s7CiAgZW5kIGxvb3A7CiAgY2xvc2UgcF9DdXJEYXRhOwplbmQ7 ICQkOwpOT1RJQ0U6ICB2YWwgPSA0MgpFUlJPUjogIGN1cnNvciAiaG9sZF9jdXJzb3IiIGRvZXMg bm90IGV4aXN0CkNPTlRFWFQ6ICBQTC9wZ1NRTCBmdW5jdGlvbiBpbmxpbmVfY29kZV9ibG9jayBs aW5lIDggYXQgRkVUQ0gKCg== --===============7867463790277145421==--