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 1rL40c-005uhh-2r for pgsql-bugs@arkaria.postgresql.org; Wed, 03 Jan 2024 16:22:22 +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 1rL40a-006UEa-Ov for pgsql-bugs@arkaria.postgresql.org; Wed, 03 Jan 2024 16:22:20 +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 1rL01d-0056HT-67 for pgsql-bugs@lists.postgresql.org; Wed, 03 Jan 2024 12:07: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 1rL01a-00DWsg-77 for pgsql-bugs@lists.postgresql.org; Wed, 03 Jan 2024 12:07: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=Y444IYc9Jrj82H251Plq2tLBEzaEMHOOaY+r6bDLv/8=; b=6iRCOmdyRF1CKQbTfRDITqgwyB Rp6fl/gB4KTiR7iwbExqoaEsQf7CG/wmNJLBQnyTmYBnw1QwxIb1+QeXNuBcvUTgqc8zIumSwCq4z UtW7X7VC1oZyBCEyeTV+1bwXV/2sp7j2KmlCr1V6CKJtWn953MyHoYcTdeqMUZuulu5xtg+6Q/kXK 5ODfY8Eghi78z0xgSaQYp2ARl5MejqyCiDrYAYG/9M3lnCLqZNhv8XDG0ZEmVY12f5Tk3b4eqxGRL hy0Br+W0LAWtsVHrztAGBR4TlGr9+k8wIiNzFwdyd7CQG5uHvgjDGUYRH6Utv23CzDrStUg727uYB M10WZdTg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rL01Y-00AZj5-Lv for pgsql-bugs@lists.postgresql.org; Wed, 03 Jan 2024 12:07:05 +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 1rL01V-006Eqk-TQ for pgsql-bugs@lists.postgresql.org; Wed, 03 Jan 2024 12:07:03 +0000 Content-Type: multipart/mixed; boundary="===============1159038568113457178==" MIME-Version: 1.0 Subject: BUG #18267: Logical replication bug: data is not synchronized after Alter Publication. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sytoptimisprime@163.com Reply-To: sytoptimisprime@163.com, pgsql-bugs@lists.postgresql.org Date: Wed, 03 Jan 2024 12:06:40 +0000 Message-ID: <18267-a1680726adf7c85d@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 --===============1159038568113457178== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI2NwpMb2dnZWQgYnk6ICAgICAgICAgIHNvbmcgeXV0YW8KRW1haWwg YWRkcmVzczogICAgICBzeXRvcHRpbWlzcHJpbWVAMTYzLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE1LjUKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSGkg aGFja2VycywgSSBmb3VuZCB3aGVuIGluc2VydCBwbGVudHkgb2YgZGF0YSBpbnRvIGEgdGFibGUs IGFuZCBhZGQgdGhlCnRhYmxlIHRvIHB1YmxpY2F0aW9uICh0aHJvdWdoIEFsdGVyIFB1YmxpY2F0 aW9uKSBtZWFud2hpbGUsIGl0J3MgbGlrZWx5IHRoYXQKdGhlIGluY3JlbWVudGFsIGRhdGEgY2Fu bm90IGJlIHN5bmNocm9uaXplZCB0byB0aGUgc3Vic2NyaWJlci4gSGVyZSBpcyBteQp0ZXN0IG1l dGhvZDoNCg0KMS4gT24gcHVibGlzaGVyIGFuZCBzdWJzY3JpYmVyLCBjcmVhdGUgdGFibGUgZm9y IHRlc3Q6DQpDUkVBVEUgVEFCTEUgdGFiXzEgKGEgaW50KTsNCg0KMi4gU2V0dXAgbG9naWNhbCBy ZXBsaWNhdGlvbjoNCm9uIHB1Ymxpc2hlcjogIA0KICAgICBTRUxFQ1QgcGdfY3JlYXRlX2xvZ2lj YWxfcmVwbGljYXRpb25fc2xvdCgnc2xvdDEnLCAncGdvdXRwdXQnLCBmYWxzZSwKZmFsc2UpOyAN CiAgICAgICAgICAgICAgICAgICAgICAgQ1JFQVRFIFBVQkxJQ0FUSU9OIHRhcF9wdWI7DQpvbiBz dWJzY3JpYmVyOiAgDQogICAgIENSRUFURSBTVUJTQ1JJUFRJT04gdGFwX3N1YiBDT05ORUNUSU9O ICckcHVibGlzaGVyX2Nvbm5zdHInIFBVQkxJQ0FUSU9OCnRhcF9wdWIgV0lUSCAoZW5hYmxlZCA9 IHRydWUsIGNyZWF0ZV9zbG90ID0gZmFsc2UsIHNsb3RfbmFtZT0nc2xvdDEnKQ0KDQozLiBQZXJm b3JtIEluc2VydO+8miAJDQogICAgIGZvciAobXkgJGkgPSAxOyAkaSA8PSAxMDAwOyAkaSsrKSB7 DQogICAgICAgICAkbm9kZV9wdWJsaXNoZXItPnNhZmVfcHNxbCgncG9zdGdyZXMnLCAiSU5TRVJU IElOVE8gdGFiXzEgU0VMRUNUCmdlbmVyYXRlX3NlcmllcygxLCAxMDAwKSIpOw0KICAgICB9DQog ICAgIEVhY2ggdHJhbnNhY3Rpb24gY29udGFpbnMgMTAwMCBpbnNlcnRpb24sIGFuZCAxMDAwIHRy YW5zYWN0aW9ucyBhcmUgaW4KdG90YWwuDQoNCjQuIFdoZW4gcGVyZm9ybWluZyBzdGVwIDMsIGFk ZCB0YWJsZSB0YWJfMSAgdG8gcHVibGljYXRpb24uDQogICAgIEFMVEVSIFBVQkxJQ0FUSU9OIHRh cF9wdWIgQUREIFRBQkxFIHRhYl8xDQogICAgIEFMVEVSIFNVQlNDUklQVElPTiB0YXBfc3ViIFJF RlJFU0ggUFVCTElDQVRJT04NCg0KVGhlIHJvb3QgY2F1c2Ugb2YgdGhlIHByb2JsZW0gaXMgYXMg Zm9sbG93czoNCnBnb3V0cHV0IHJlbGllcyBvbiB0aGUgaW52YWxpZGF0aW9uIG1lY2hhbmlzbSB0 byB2YWxpZGF0ZSBwdWJsaWNhdGlvbnMuIFdoZW4Kd2Fsc2VuZGVyIGRlY29kaW5nIGFuIEFsdGVy IFB1YmxpY2F0aW9uIHRyYW5zYWN0aW9uLCBjYXRhbG9nIGNhY2hlcyBhcmUKaW52YWxpZGF0ZWQg YXQgb25jZS4gRnVydGhlcm1vcmUsIHNpbmNlIHBnX3B1YmxpY2F0aW9uX3JlbCBpcyBtb2RpZmll ZCwKc25hcHNob3QgY2hhbmdlcyBhcmUgYWRkZWQgdG8gYWxsIHRyYW5zYWN0aW9ucyBjdXJyZW50 bHkgYmVpbmcgZGVjb2RlZC4gRm9yCm90aGVyIHRyYW5zYWN0aW9ucywgY2F0YWxvZyBjYWNoZXMg aGF2ZSBiZWVuIGludmFsaWRhdGVkLiBIb3dldmVyLCBpdCBpcwpsaWtlbHkgdGhhdCB0aGUgc25h cHNob3QgY2hhbmdlcyBoYXZlIG5vdCB5ZXQgYmVlbiBkZWNvZGVkLiBJbiBwZ291dHB1dAppbXBs ZW1lbnRhdGlvbiwgdGhlc2UgdHJhbnNhY3Rpb25zIHF1ZXJ5IHRoZSBzeXN0ZW0gdGFibGUgcGdf cHVibGljYXRpb25fcmVsCnRvIGRldGVybWluZSB3aGV0aGVyIHRvIHB1Ymxpc2ggY2hhbmdlcyBt YWRlIGluIHRyYW5zYWN0aW9ucy4gSW4gdGhpcyBjYXNlLApjYXRhbG9nIHR1cGxlcyBhcmUgbm90 IGZvdW5kIGJlY2F1c2Ugc25hcHNob3QgaGFzIG5vdCBiZWVuIHVwZGF0ZWQuIEFzIGEKcmVzdWx0 LCBjaGFuZ2VzIGluIHRyYW5zYWN0aW9ucyBhcmUgY29uc2lkZXJlZCBub3QgdG8gYmUgcHVibGlz aGVkLCBhbmQKc3Vic2VxdWVudCBkYXRhIGNhbm5vdCBiZSBzeW5jaHJvbml6ZWQuDQoNCkkgdGhp bmsgaXQncyBuZWNlc3NhcnkgdG8gYWRkIGludmFsaWRhdGlvbnMgdG8gb3RoZXIgdHJhbnNhY3Rp b25zIGFmdGVyCmFkZGluZyBhIHNuYXBzaG90IGNoYW5nZSB0byB0aGVtLg0KVGhlcmVmb3JlLCBJ IHN1Ym1pdHRlZCBhIHBhdGNoIGZvciB0aGlzIGJ1Zy4KCg== --===============1159038568113457178==--