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 1mBZ3q-0003Ax-Ef for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Aug 2021 08:49:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mBZ3o-0001Kd-Rb for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Aug 2021 08:49:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mBSlt-0000Eg-Rz for pgsql-bugs@lists.postgresql.org; Thu, 05 Aug 2021 02:06:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mBSlp-00072r-AW for pgsql-bugs@lists.postgresql.org; Thu, 05 Aug 2021 02:06: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=IzbZhftE2MhRDIqI5aIjlFXBXkHI/jHLsUN3mHKZPVs=; b=U2wQwgq03z05Lq6SU4Q1QFvMap MpEjeEg0VRF2jTO1GDkHAdUGhJOjMXlvvkMOH+KGEra6UhEQwR9DIqNC8SI4uFoFyVWjWsMwrmTCT RnuZ9U8noS4jRP/takslA0GmcTJAHWMllojDJGjgeqqBODAiBu9HUIzu+apr8HHnXB47R+3CyMiO9 zL668bEvXC7q5rpIknjVaIJ2A5iNo2mPls1SJLX+xa43ybLX+yerXl4IN1rLkEpfFcJ4r9FFINPof o8JQUDKpjktEaVz0o+C5nMhSf7S+Q17IZLtxdFH2aNsisAMvky7zIFKndvgxh/UlKDiPYtUSbPXgr PajDWn4w==; 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 1mBSlo-0008OO-2Q for pgsql-bugs@lists.postgresql.org; Thu, 05 Aug 2021 02:06:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mBSlm-0003V6-QB for pgsql-bugs@lists.postgresql.org; Thu, 05 Aug 2021 02:06:02 +0000 Content-Type: multipart/mixed; boundary="===============6827125651294871249==" MIME-Version: 1.0 Subject: BUG #17132: About "ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: chenjq.jy@fujitsu.com Reply-To: chenjq.jy@fujitsu.com, pgsql-bugs@lists.postgresql.org Date: Thu, 05 Aug 2021 02:05:55 +0000 Message-ID: <17132-6a702189086c6243@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 --===============6827125651294871249== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzEzMgpMb2dnZWQgYnk6ICAgICAgICAgIENoZW4gSmlhb3FpYW4KRW1h aWwgYWRkcmVzczogICAgICBjaGVuanEuanlAZnVqaXRzdS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNGJldGEyCk9wZXJhdGluZyBzeXN0ZW06ICAgUmVkIEhhdCBFbnRlcnByaXNlIExpbnV4IFNl cnZlciByZWxlYXNlIDcuOApEZXNjcmlwdGlvbjogICAgICAgIAoKSGksIEF1dGhvcg0KICAgIA0K ICAgIFdoZW4gSSB1c2UgIkFMVEVSIFNVQlNDUklQVElPTiAuLi4gQUREL0RST1AgUFVCTElDQVRJ T04iIHRvIGFkZC9kcm9wCnB1YmxpY2F0aW9uLCB0aGUgY291bnQgb2YgZGF0YSBpcyBzdHJhbmdl IGFmdGVyIHJlLWFkZGluZyBkcm9wcGVkCnB1YmxpY2F0aW9uLg0KICAgIEFzIGZhciBhcyBJIGtu b3csIHRoZXJlIGFyZSB0d28gd2F5cyB0byBhZGQvZHJvcCBzdWJzY3JpYmVkIHB1YmxpY2F0aW9u cwppbiBQRzE0IGJldGEyOg0KICAgICAgICAxKSBBTFRFUiBTVUJTQ1JJUFRJT04gLi4uIEFERC9E Uk9QIFBVQkxJQ0FUSU9OIChQRzE0IG5ldyBmZWF0dXJlKQ0KICAgICAgICAyKSBBTFRFUiBTVUJT Q1JJUFRJT04gLi4uIFNFVCBQVUJMSUNBVElPTiAoZXhpc3RpbmcgZmVhdHVyZSkNCg0KICAgIFVz ZSB0aGUgYWJvdmUgdHdvIHdheXMgdG8gcGVyZm9ybSB0aGUgZm9sbG93aW5nIG9wZXJhdGlvbnM6 DQogICAgICAgIFN0ZXAgMS4gQ3JlYXRlIHR3byBpbnN0YW5jZXMsIG9uZSBhcyB0aGUgcHVibGlz aGVyIGFuZCBvbmUgYXMgdGhlCnN1YnNjcmliZXIuDQogICAgICAgIFN0ZXAgMi4gT24gdGhlIHB1 Ymxpc2hlciwgY3JlYXRlIHR3byB0YWJsZXMgdGVzdDEgYW5kIHRlc3QyIGFuZAppbnNlcnQgYSBw aWVjZSBvZiBkYXRhIGludG8gdGVzdDIsIA0KICAgICAgICAgICAgICAgIGFuZCBjcmVhdGUgcHVi bGljYXRpb24gcHViMSBmb3IgdGVzdDEsIHB1YmxpY2F0aW9uIHB1YjIgZm9yCnRlc3QyLg0KICAg ICAgICBTdGVwIDMuIE9uIHRoZSBzdWJzY3JpYmVyLCBjcmVhdGUgdHdvIHRhYmxlcyB0ZXN0MSBh bmQgdGVzdDIgdGhhdAphcmUgdGhlIHNhbWUgYXMgdGhvc2Ugb24gdGhlIHB1Ymxpc2hlciwgDQog ICAgICAgICAgICAgICAgYW5kIGNyZWF0ZSBhIHN1YnNjcmlwdGlvbiBzdWIgdG8gc3Vic2NyaWJl IHRvIHB1YjEuIFRoZW4gYWRkCnB1YjIgaW50byB0aGUgc3ViLg0KICAgICAgICBTdGVwIDQuIERy b3AgcHViMiBmcm9tIHRoZSBsaXN0IG9mIHB1YmxpY2F0aW9ucyBvbiBzdWIuDQogICAgICAgIFN0 ZXAgNS4gT24gdGhlIHB1Ymxpc2hlciwgaW5zZXJ0IGEgbmV3IHBpZWNlIG9mIGRhdGEgaW50byB0 ZXN0Mi4NCiAgICAgICAgU3RlcCA2LiBPbiB0aGUgc3Vic2NyaWJlciwgcmUtYWRkIHB1YjIgaW50 byB0aGUgc3ViLg0KICAgIA0KICAgIEF0IHRoaXMgdGltZSwgc2VsZWN0IHRoZSBkYXRhIGZyb20g dGVzdDIgb24gdGhlIHN1YnNjcmliZXIuDQogICAgVXNlIHdheSAxKSwgdGFibGUgdGVzdDIgaGFz IG9ubHkgb25lIHBpZWNlIG9mIGRhdGEgZnJvbSBTdGVwIDIuDQogICAgVXNlIHdheSAyKSwgdGFi bGUgdGVzdDIgaGFzIHRocmVlIHBpZWNlcyBvZiBkYXRhLCBvbmUgZnJvbSBTdGVwIDIgYW5kCnR3 byBmcm9tIFN0ZXAgNS4NCiAgICBUaGUgZGV0YWlscyBvZiB0aGUgc3RlcHMgZm9yIHRoZSBhYm92 ZSB0d28gd2F5cyBhcmUgYXMgZm9sbG93Og0KDQogICAg4pagIFVzZSB3YXkgMSkNCiAgICDil48g T24gdGhlIHB1Ymxpc2hlcg0KICAgIGNyZWF0ZSB0YWJsZSB0ZXN0MShpZCBpbnQpOw0KICAgIGNy ZWF0ZSB0YWJsZSB0ZXN0MihpZCBpbnQpOw0KICAgIGluc2VydCBpbnRvIHRlc3QyIHZhbHVlcygy KTsNCiAgICBjcmVhdGUgcHVibGljYXRpb24gcHViMSBmb3IgdGFibGUgdGVzdDE7DQogICAgY3Jl YXRlIHB1YmxpY2F0aW9uIHB1YjIgZm9yIHRhYmxlIHRlc3QyOw0KICAgIA0KICAgIOKXjyBPbiB0 aGUgc3Vic2NyaWJlcg0KICAgIGNyZWF0ZSB0YWJsZSB0ZXN0MShpZCBpbnQpOw0KICAgIGNyZWF0 ZSB0YWJsZSB0ZXN0MihpZCBpbnQpOw0KICAgIGNyZWF0ZSBzdWJzY3JpcHRpb24gc3ViIGNvbm5l Y3Rpb24gJ2RibmFtZT1wb3N0Z3JlcywgLi4uJyBwdWJsaWNhdGlvbgpwdWIxOw0KICAgIEFMVEVS IFNVQlNDUklQVElPTiBzdWIgQUREIFBVQkxJQ0FUSU9OIHB1YjIgd2l0aCAocmVmcmVzaCA9IHRy dWUpOw0KICAgIHNlbGVjdCAqIGZyb20gdGVzdDI7ICAgLS0gc2VsZWN0IHRoZSBkYXRhIGFmdGVy IGFkZGluZyBwdWJsaWNhdGlvbgpwdWIyDQogICAgaWQNCiAgICAtLS0tDQogICAgMg0KICAgICgx IHJvdykNCg0KICAgIEFMVEVSIFNVQlNDUklQVElPTiBzdWIgRFJPUCBQVUJMSUNBVElPTiBwdWIy IHdpdGggKHJlZnJlc2ggPSB0cnVlKTsNCiAgICBzZWxlY3QgKiBmcm9tIHRlc3QyOyAgIC0tIHNl bGVjdCB0aGUgZGF0YSBhZnRlciBkcm9wcGluZyBwdWIyDQogICAgaWQNCiAgICAtLS0tDQogICAg Mg0KICAgICgxIHJvdykNCg0KICAgIOKXjyBPbiB0aGUgcHVibGlzaGVyDQogICAgaW5zZXJ0IGlu dG8gdGVzdDIgdmFsdWVzKDMpOw0KDQogICAg4pePIE9uIHRoZSBzdWJzY3JpYmVyDQogICAgQUxU RVIgU1VCU0NSSVBUSU9OIHN1YiBBREQgUFVCTElDQVRJT04gcHViMiB3aXRoIChyZWZyZXNoID0g dHJ1ZSk7DQogICAgc2VsZWN0ICogZnJvbSB0ZXN0MjsgICAtLSBzZWxlY3QgdGhlIGRhdGEgYWZ0 ZXIgcmUtYWRkaW5nIGRyb3BwZWQgcHViMg0KICAgIGlkDQogICAgLS0tLQ0KICAgIDINCiAgICAo MSByb3cpDQogICAgDQogICAg4pagIFVzZSB3YXkgMikNCiAgICDil48gT24gdGhlIHB1Ymxpc2hl cg0KICAgIGNyZWF0ZSB0YWJsZSB0ZXN0MShpZCBpbnQpOw0KICAgIGNyZWF0ZSB0YWJsZSB0ZXN0 MihpZCBpbnQpOw0KICAgIGluc2VydCBpbnRvIHRlc3QyIHZhbHVlcygyKTsNCiAgICBjcmVhdGUg cHVibGljYXRpb24gcHViMSBmb3IgdGFibGUgdGVzdDE7DQogICAgY3JlYXRlIHB1YmxpY2F0aW9u IHB1YjIgZm9yIHRhYmxlIHRlc3QyOw0KICAgIA0KICAgIOKXjyBPbiB0aGUgc3Vic2NyaWJlcg0K ICAgIGNyZWF0ZSB0YWJsZSB0ZXN0MShpZCBpbnQpOw0KICAgIGNyZWF0ZSB0YWJsZSB0ZXN0Mihp ZCBpbnQpOw0KICAgIGNyZWF0ZSBzdWJzY3JpcHRpb24gc3ViIGNvbm5lY3Rpb24gJ2RibmFtZT1w b3N0Z3JlcywgLi4uJyBwdWJsaWNhdGlvbgpwdWIxOw0KICAgIEFMVEVSIFNVQlNDUklQVElPTiBz dWIgU0VUIFBVQkxJQ0FUSU9OIHB1YjEscHViMiB3aXRoIChyZWZyZXNoID0KdHJ1ZSk7DQogICAg c2VsZWN0ICogZnJvbSB0ZXN0MjsgICAtLSBzZWxlY3QgdGhlIGRhdGEgYWZ0ZXIgYWRkaW5nIHB1 YmxpY2F0aW9uCnB1YjINCiAgICBpZA0KICAgIC0tLS0NCiAgICAyDQogICAgKDEgcm93KQ0KICAg IEFMVEVSIFNVQlNDUklQVElPTiBzdWIgU0VUIFBVQkxJQ0FUSU9OIHB1YjEgd2l0aCAocmVmcmVz aCA9IHRydWUpOw0KICAgIHNlbGVjdCAqIGZyb20gdGVzdDI7ICAgLS0gc2VsZWN0IHRoZSBkYXRh IGFmdGVyIGRyb3BwaW5nIHB1YjINCiAgICBpZA0KICAgIC0tLS0NCiAgICAyDQogICAgKDEgcm93 KQ0KICAgIA0KICAgIOKXjyBPbiB0aGUgcHVibGlzaGVyDQogICAgaW5zZXJ0IGludG8gdGVzdDIg dmFsdWVzKDMpOw0KDQogICAg4pePIE9uIHRoZSBzdWJzY3JpYmVyDQogICAgQUxURVIgU1VCU0NS SVBUSU9OIHN1YiBTRVQgUFVCTElDQVRJT04gcHViMSxwdWIyIHdpdGggKHJlZnJlc2ggPQp0cnVl KTsNCiAgICBzZWxlY3QgKiBmcm9tIHRlc3QyOyAgIC0tIHNlbGVjdCB0aGUgZGF0YSBhZnRlciBy ZS1hZGRpbmcgZHJvcHBlZCBwdWIyDQogICAgaWQNCiAgICAtLS0tDQogICAgMg0KICAgIDINCiAg ICAzDQogICAgKDMgcm93cykNCiAgICANCiAgICBJIHRoaW5rIEFERC9EUk9QIGFuZCBTRVQgY2xh dXNlIGFyZSBzaW1pbGFyLCBzaG91bGRuJ3QgdGhlIGRhdGEgaW4gdGhlCnRhYmxlIGJlIGNvbnNp c3RlbnQgYWZ0ZXIgcmUtYWRkaW5nIHRoZSBkcm9wcGVkIHB1YmxpY2F0aW9uPwoK --===============6827125651294871249==--