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 1sIDTB-00DxRu-9I for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Jun 2024 20:24:21 +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 1sIDT9-005fuC-0R for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Jun 2024 20:24:19 +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 1sIBDc-004Ipp-QS for pgsql-bugs@lists.postgresql.org; Fri, 14 Jun 2024 18:00:09 +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.94.2) (envelope-from ) id 1sIBDa-001JbB-MK for pgsql-bugs@lists.postgresql.org; Fri, 14 Jun 2024 18:00:08 +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=mfU5/2/a3GM3qJGVjVDE76tKsZhqQM1Yq+ptSNVhgeg=; b=bamV3Fl4AU9jJaghp60TL0a2N6 VGm6MAt/gq/AEvBkCjGDnDpe3o/cYCYCFDZglp9Eb/5kaE9oCByV44zzQ+3dKeUSocEck6AovynSy jtTJCD/Pc8lh08+fFdyKNG/SmmR9fJV+FTu9DgmT0YGFVwudgppDt5grYBnfzveADQJWwO+42lgHR XMFKMgt2N+d9BayqLRe4f1z3NH6CkEdGKUD6UZeq6T7FTFw4Lq6LNHyNL8BoEgNnTdyMTpxHdYW5y 6+FeesSI4DLNxErwoyb1i91ooSZzYgW4vcoLEXsFfCaHwqfzorwB0vZzOrR9/c9GSzVzPqBt9YLYY luxlAgXw==; 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 1sIBDa-004Axl-4L for pgsql-bugs@lists.postgresql.org; Fri, 14 Jun 2024 18:00:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sIBDX-007fGz-DI for pgsql-bugs@lists.postgresql.org; Fri, 14 Jun 2024 18:00:04 +0000 Content-Type: multipart/mixed; boundary="===============7224291114811301717==" MIME-Version: 1.0 Subject: BUG #18509: Logical decoding behaves badly when processing a change record for a table with altered column To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Jun 2024 18:00:01 +0000 Message-ID: <18509-983f064d174ea880@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 --===============7224291114811301717== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODUwOQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTdiZXRhMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpudW1qb2JzPTEwDQpmb3IgKChqPTE7ajw9 bnVtam9icztqKyspKTsgZG8NCnBzcWwgLWMgIkNSRUFURSBUQUJMRSB0JGoodDEgdGV4dCwgaTIg aW50KTsiDQpkb25lDQoNCmZvciBpIGluIGBzZXEgNTBgOyBkbw0KZWNobyAiaXRlcmF0aW9uICRp IjsNCg0KZm9yICgoaj0xO2o8PW51bWpvYnM7aisrKSk7IGRvDQpjYXQgPDwgRU9GIHwgcHNxbCA+ L2Rldi9udWxsICYNCkJFR0lOOw0KU0VMRUNUIHR4aWRfY3VycmVudCgpOw0KU0VMRUNUIHBnX3Ns ZWVwKDAuMDEpOw0KRU9GDQoNCmNhdCA8PCBFT0YgfCBwc3FsID4vZGV2L251bGwgJg0KQUxURVIg VEFCTEUgdCRqIFJFTkFNRSBDT0xVTU4gdDEgVE8gaTE7DQpTRUxFQ1QgcGdfc2xlZXAoMC4wMDEp Ow0KQUxURVIgVEFCTEUgdCRqIEFMVEVSIENPTFVNTiBpMSBUWVBFIGludDQgVVNJTkcgKGkxOjpp bnQ0KTsNClNFTEVDVCBwZ19zbGVlcCgwLjAwMSk7DQpJTlNFUlQgSU5UTyB0JGooaTEpIFZBTFVF UyAoMSk7DQpTRUxFQ1QgcGdfc2xlZXAoMC4wMDEpOw0KSU5TRVJUIElOVE8gdCRqKGkxKSBWQUxV RVMgKDEpOw0KU0VMRUNUIHBnX3NsZWVwKDAuMDAxKTsNCklOU0VSVCBJTlRPIHQkaihpMSkgVkFM VUVTICgxKTsNCkVPRg0KDQpjYXQgPDwgRU9GIHwgcHNxbCA+L2Rldi9udWxsICYNClNFTEVDVCAn aW5pdCcgRlJPTSBwZ19jcmVhdGVfbG9naWNhbF9yZXBsaWNhdGlvbl9zbG90KA0KICAncmVncmVz c2lvbl9zbG90JGonLCAndGVzdF9kZWNvZGluZycpOw0KDQpTRUxFQ1QgZGF0YSBGUk9NIHBnX2xv Z2ljYWxfc2xvdF9nZXRfY2hhbmdlcygNCiAgJ3JlZ3Jlc3Npb25fc2xvdCRqJywgTlVMTCxOVUxM KTsNCkVPRg0KZG9uZQ0Kd2FpdA0KDQpmb3IgKChqPTE7ajw9bnVtam9icztqKyspKTsgZG8NCmNh dCA8PCBFT0YgfCBwc3FsID4vZGV2L251bGwNClNFTEVDVCBwZ19kcm9wX3JlcGxpY2F0aW9uX3Ns b3QoJ3JlZ3Jlc3Npb25fc2xvdCRqJyk7DQpBTFRFUiBUQUJMRSB0JGogQUxURVIgQ09MVU1OIGkx IFRZUEUgdGV4dCBVU0lORyAoaTE6OnRleHQpOw0KQUxURVIgVEFCTEUgdCRqIFJFTkFNRSBDT0xV TU4gaTEgVE8gdDE7DQpFT0YNCmRvbmUNCg0KZ3JlcCAnVFJBUCcgc2VydmVyLmxvZyAgJiYgeyBi cmVhazsgfQ0KZG9uZQ0KDQpwcm9kdWNlcyBlcnJvcnMgbGlrZToNCjIwMjQtMDYtMTQgMTc6MTA6 NTguMzQ5IFVUQ3xsYXd8cmVncmVzc2lvbnw2NjZjNzlhMi4zZmUzYTR8RVJST1I6ICBjb3VsZCBu b3QKbWFwIGZpbGVudW1iZXIgImJhc2UvMTYzODQvMTY0NTMiIHRvIHJlbGF0aW9uIE9JRA0KMjAy NC0wNi0xNCAxNzoxMDo1OC4zNDkgVVRDfGxhd3xyZWdyZXNzaW9ufDY2NmM3OWEyLjNmZTNhNHxC QUNLVFJBQ0U6DQpSZW9yZGVyQnVmZmVyUHJvY2Vzc1RYTiBhdCByZW9yZGVyYnVmZmVyLmM6MjIx ODo3DQpSZW9yZGVyQnVmZmVyUmVwbGF5IGF0IHJlb3JkZXJidWZmZXIuYzoyNzAxOjINClJlb3Jk ZXJCdWZmZXJDb21taXQgYXQgcmVvcmRlcmJ1ZmZlci5jOjI3MjU6Mg0KRGVjb2RlQ29tbWl0IGF0 IGRlY29kZS5jOjczMzozDQp4YWN0X2RlY29kZSBhdCBkZWNvZGUuYzoyNDM6NQ0KTG9naWNhbERl Y29kaW5nUHJvY2Vzc1JlY29yZCBhdCBkZWNvZGUuYzoxMjM6MQ0KcGdfbG9naWNhbF9zbG90X2dl dF9jaGFuZ2VzX2d1dHMgYXQgbG9naWNhbGZ1bmNzLmM6MjY5OjcNCnBnX2xvZ2ljYWxfc2xvdF9n ZXRfY2hhbmdlcyBhdCBsb2dpY2FsZnVuY3MuYzozMzQ6MQ0KLi4uDQoyMDI0LTA2LTE0IDE3OjEw OjU4LjM0OSBVVEN8bGF3fHJlZ3Jlc3Npb258NjY2Yzc5YTIuM2ZlM2E0fFNUQVRFTUVOVDogClNF TEVDVCBkYXRhIEZST00gcGdfbG9naWNhbF9zbG90X2dldF9jaGFuZ2VzKA0KICAgICAgJ3JlZ3Jl c3Npb25fc2xvdDMnLCBOVUxMLE5VTEwpOw0KDQphbmQgYW4gYXNzZXJ0aW9uIGZhaWx1cmU6DQpU UkFQOiBmYWlsZWQgQXNzZXJ0KCJUdXBsZURlc2NBdHRyKHJlbGF0aW9uLT5yZF9hdHQsIGkpLT5h dHRjYWNoZW9mZiA9PQotMSIpLCBGaWxlOiAicmVsY2FjaGUuYyIsIExpbmU6IDY3MywgUElEOiA0 MTg3MTU2DQouLi4NCiMzICAweDAwMDA3ZjAzYzY5MGU0NzYgaW4gX19HSV9yYWlzZSAoc2lnPXNp Z0BlbnRyeT02KSBhdAouLi9zeXNkZXBzL3Bvc2l4L3JhaXNlLmM6MjYNCiM0ICAweDAwMDA3ZjAz YzY4ZjQ3ZjMgaW4gX19HSV9hYm9ydCAoKSBhdCAuL3N0ZGxpYi9hYm9ydC5jOjc5DQojNSAgMHgw MDAwNTVjM2M4NmQ5NWYxIGluIEV4Y2VwdGlvbmFsQ29uZGl0aW9uICgNCiAgICBjb25kaXRpb25O YW1lPTB4NTVjM2M4OTMwMTk4ICJUdXBsZURlc2NBdHRyKHJlbGF0aW9uLT5yZF9hdHQsCmkpLT5h dHRjYWNoZW9mZiA9PSAtMSIsIA0KICAgIGZpbGVOYW1lPTB4NTVjM2M4OTMwMTA4ICJyZWxjYWNo ZS5jIiwgbGluZU51bWJlcj02NzMpIGF0IGFzc2VydC5jOjY2DQojNiAgMHgwMDAwNTVjM2M4NmMy ZGQzIGluIFJlbGF0aW9uQnVpbGRUdXBsZURlc2MgKHJlbGF0aW9uPTB4N2YwM2I3NWRkMWE4KQph dCByZWxjYWNoZS5jOjY3Mw0KIzcgIDB4MDAwMDU1YzNjODZjM2NlNiBpbiBSZWxhdGlvbkJ1aWxk RGVzYyAodGFyZ2V0UmVsSWQ9MTY0MzAsCmluc2VydEl0PXRydWUpIGF0IHJlbGNhY2hlLmM6MTE4 NQ0KIzggIDB4MDAwMDU1YzNjODZjNTkyMiBpbiBSZWxhdGlvbklkR2V0UmVsYXRpb24gKHJlbGF0 aW9uSWQ9MTY0MzApIGF0CnJlbGNhY2hlLmM6MjExNg0KIzkgIDB4MDAwMDU1YzNjODQyODI3NiBp biBSZW9yZGVyQnVmZmVyUHJvY2Vzc1RYTiAoLi4uKSBhdApyZW9yZGVyYnVmZmVyLmM6MjIyMg0K IzEwIDB4MDAwMDU1YzNjODQyOTBjNSBpbiBSZW9yZGVyQnVmZmVyUmVwbGF5ICguLi4pIGF0CnJl b3JkZXJidWZmZXIuYzoyNzAxDQojMTEgMHgwMDAwNTVjM2M4NDI5MTQ3IGluIFJlb3JkZXJCdWZm ZXJDb21taXQgKC4uLikgYXQKcmVvcmRlcmJ1ZmZlci5jOjI3MjUNCiMxMiAweDAwMDA1NWMzYzg0 MTQzNTAgaW4gRGVjb2RlQ29tbWl0ICguLi4pIGF0IGRlY29kZS5jOjczMw0KIzEzIDB4MDAwMDU1 YzNjODQxMzVhMSBpbiB4YWN0X2RlY29kZSAoLi4uKSBhdCBkZWNvZGUuYzoyNDINCiMxNCAweDAw MDA1NWMzYzg0MTMwZmIgaW4gTG9naWNhbERlY29kaW5nUHJvY2Vzc1JlY29yZCAoLi4uKSBhdApk ZWNvZGUuYzoxMTYNCiMxNSAweDAwMDA1NWMzYzg0MWNlNjAgaW4gcGdfbG9naWNhbF9zbG90X2dl dF9jaGFuZ2VzX2d1dHMgKC4uLikgYXQKbG9naWNhbGZ1bmNzLmM6MjY2DQojMTYgMHgwMDAwNTVj M2M4NDFjZmQxIGluIHBnX2xvZ2ljYWxfc2xvdF9nZXRfY2hhbmdlcyAoLi4uKSBhdApsb2dpY2Fs ZnVuY3MuYzozMzMNCi4uLg0KDQpBbHNvLCB3aXRoIHRhYmxlcyBjcmVhdGVkIGFzICJDUkVBVEUg VEFCTEUgdCRqKHQxIHRleHQpOyIgaXQgcHJvZHVjZXM6DQpXQVJOSU5HOiAgcHJvYmxlbSBpbiBh bGxvYyBzZXQgdGV4dCBjb252ZXJzaW9uIGNvbnRleHQ6IGJhZCBibG9jayBvZmZzZXQgZm9yCmNo dW5rIDB4NTViZGI1MWNlZDE4IGluIGJsb2NrIDB4NTViZGI1MWNlMGM4DQooYW5kIG90aGVyICJw cm9ibGVtIGluIGFsbG9jIiB3YXJuaW5ncykNCmFuZA0KVFJBUDogZmFpbGVkIEFzc2VydCgiIUhk ck1hc2tJc0V4dGVybmFsKGNodW5rLT5oZHJtYXNrKSB8fApIZHJNYXNrQ2hlY2tNYWdpYyhjaHVu ay0+aGRybWFzaykiKSwgRmlsZToKIi4uLy4uLy4uLy4uL3NyYy9pbmNsdWRlL3V0aWxzL21lbXV0 aWxzX21lbW9yeWNodW5rLmgiLCBMaW5lOiAyMTAsIFBJRDoKNDE4ODI1OQ0KDQpSZXByb2R1Y2Vk IG9uIFJFTF8xMl9TVEFCTEUgLi4gbWFzdGVyLgoK --===============7224291114811301717==--