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 1pSlUV-00063u-Mz for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Feb 2023 21:08:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pSlUU-0003M3-JU for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Feb 2023 21:08:30 +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 1pSlUT-0003Lu-Ut for pgsql-hackers@lists.postgresql.org; Thu, 16 Feb 2023 21:08:30 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSlUO-0005PD-U0 for pgsql-hackers@lists.postgresql.org; Thu, 16 Feb 2023 21:08:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:Subject:References: Cc:To:From:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=G/SiB1aCp/6n9c8O15J6yYVMfg40YAPr68qLCRlUeCk=; b=GZZvMBL01ZJ3OsYUboKRzuouYn 8JTkyLpLeLnwgdfdSDaURj8K1dfYxWQRNRaO+lqhxQ48OC9ySeezpBc/kxaOpN2EjXmThXYpZuy8o 8XCAQq+JkegKfQzKsWvR4GiDq2+lX24vv5p1ws4dr6aFHScMpx6IWrrSM2M0JO2uUY39VVkRQSKo4 3GVIB6ScPupet2FIUVaLRERYJ2jFQWuQzg3XyH11fbyt8Cl/m+J5V/p30FeCVAqeRxlU+cXLMkdWt gWnlL8+K5skQKtCGxh6IzqZ6BB8ebqXVLNZDQ8mFmBWtLEWT98Oo8U/aNs42ITWAI1UVHPfGeRo3v 2Za3wzXg==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pSlUI-000781-Sf; Thu, 16 Feb 2023 21:08:21 +0000 Message-ID: Date: Thu, 16 Feb 2023 16:08:14 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.7.2 Content-Language: en-US From: "Jonathan S. Katz" To: Alvaro Herrera Cc: "houzj.fnst@fujitsu.com" , Amit Kapila , Ajin Cherian , Peter Smith , vignesh C , Zheng Li , li jie , Dilip Kumar , Masahiko Sawada , Japin Li , rajesh singarapu , PostgreSQL Hackers References: <20230216193827.h4p6dtjg244ox5fj@alvherre.pgsql> Subject: Re: Support logical replication of DDLs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------0IW7Hc5ytlW6H4KLqKEDQldk" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------0IW7Hc5ytlW6H4KLqKEDQldk Content-Type: multipart/mixed; boundary="------------MMfgRzifaep48IBypDKhwVk0"; protected-headers="v1" From: "Jonathan S. Katz" To: Alvaro Herrera Cc: "houzj.fnst@fujitsu.com" , Amit Kapila , Ajin Cherian , Peter Smith , vignesh C , Zheng Li , li jie , Dilip Kumar , Masahiko Sawada , Japin Li , rajesh singarapu , PostgreSQL Hackers Message-ID: Subject: Re: Support logical replication of DDLs References: <20230216193827.h4p6dtjg244ox5fj@alvherre.pgsql> In-Reply-To: --------------MMfgRzifaep48IBypDKhwVk0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gMi8xNi8yMyAyOjQzIFBNLCBKb25hdGhhbiBTLiBLYXR6IHdyb3RlOg0KPiBPbiAyLzE2 LzIzIDI6MzggUE0sIEFsdmFybyBIZXJyZXJhIHdyb3RlOg0KPj4gT24gMjAyMy1GZWItMTYs IEpvbmF0aGFuIFMuIEthdHogd3JvdGU6DQo+Pg0KPj4+IE9uIDIvMTYvMjMgMTI6NTMgUE0s IEFsdmFybyBIZXJyZXJhIHdyb3RlOg0KPj4NCj4+Pj4gSSBkb24ndCB0aGluayB0aGlzIGlz IHRoZSBmYXVsdCBvZiBsb2dpY2FsIHJlcGxpY2F0aW9uLsKgIENvbnNpZGVyIHRoYXQNCj4+ Pj4gZm9yIHRoZSBiYWNrZW5kIHNlcnZlciwgdGhlIGZ1bmN0aW9uIHNvdXJjZSBjb2RlIGlz IGp1c3QgYW4gb3BhcXVlDQo+Pj4+IHN0cmluZyB0aGF0IGlzIGdpdmVuIHRvIHRoZSBwbHBn c3FsIGVuZ2luZSB0byBpbnRlcnByZXQuwqAgU28gdGhlcmUncyBubw0KPj4+PiB3YXkgZm9y IHRoZSBsb2dpY2FsIERETCByZXBsaWNhdGlvbiBlbmdpbmUgdG8gdHVybiB0aGlzIGludG8g cnVubmFibGUNCj4+Pj4gY29kZSBpZiB0aGUgdGFibGUgbmFtZSBpcyBub3QgcXVhbGlmaWVk Lg0KPj4+DQo+Pj4gU3VyZSwgdGhhdCdzIGZhaXIuIFRoYXQgc2FpZCwgdGhlIGV4YW1wbGUg YWJvdmUgd291bGQgZmFsbCB1bmRlciBhIA0KPj4+ICJ0eXBpY2FsDQo+Pj4gdXNlIGNhc2Ui LCBpLmUuIEknbSByZXBsaWNhdGluZyBmdW5jdGlvbnMgdGhhdCBjYWxsIHRhYmxlcyB3aXRo b3V0IA0KPj4+IHNjaGVtYQ0KPj4+IHF1YWxpZmljYXRpb24uIFRoaXMgaXMgcHJldHR5IGNv bW1vbiwgYW5kIGFzIGxvZ2ljYWwgcmVwbGljYXRpb24gYmVjb21lcw0KPj4+IHVzZWQgZm9y IG1vcmUgdHlwZXMgb2Ygd29ya2xvYWRzIChlLmcuIGhpZ2ggYXZhaWxhYmlsaXR5KSwgd2Un bGwgDQo+Pj4gZGVmaW5pdGVseQ0KPj4+IHNlZSB0aGlzLg0KPj4NCj4+IEhtbSwgSSB0aGlu ayB5b3UncmUgc2F5aW5nIHRoYXQgcmVwbGF5IHNob3VsZCB0dXJuIGNoZWNrX2Z1bmN0aW9u X2JvZGllcw0KPj4gb2ZmLCBhbmQgSSB0aGluayBJIGFncmVlIHdpdGggdGhhdC4NCj4gDQo+ IFllcywgZXhhY3RseS4gKzENCg0KSSBkcmlsbGVkIGludG8gdGhpcyBhIGJpdCBtb3JlIHVz aW5nIHRoZSBTUUwgc3RhbmRhcmQgYm9kaWVzIChCRUdJTiANCkFUT01JQykgdG8gc2VlIGlm IHRoZXJlIHdlcmUgYW55IG90aGVyIGJlaGF2aW9ycyB3ZSBuZWVkZWQgdG8gYWNjb3VudCAN CmZvci4gT3ZlcmFsbCwgaXQgd29ya2VkIHdlbGwgYnV0IEkgcmFuIGludG8gb25lIGlzc3Vl Lg0KDQpGaXJzdCwgZnVuY3Rpb25zIHdpdGggIkJFR0lOIEFUT01JQyIgaWdub3JlcyAiY2hl Y2tfZnVuY3Rpb25fYm9kaWVzIiANCndoaWNoIGlzIGJ5IGRlc2lnbiBiYXNlZCBvbiBob3cg dGhpcyBmZWF0dXJlIHdvcmtzLiBXZSBzaG91bGQgc3RpbGwgdHVybiANCiJjaGVja19mdW5j dGlvbl9ib2RpZXMiIHRvICJvZmYiIHRob3VnaCwgcGVyIGFib3ZlIGRpc2N1c3Npb24uDQoN CkluIHRoZSBjb250ZXh0IG9mIERETCByZXBsaWNhdGlvbiwgIkJFR0lOIEFUT01JQyIgZG9l cyBzdXBwb3J0IA0Kc2NoZW1hLXVucXVhbGlmaWVkIGZ1bmN0aW9ucywgcHJlc3VtYWJseSBi ZWNhdXNlIGl0IGluY2x1ZGVzIHRoZSBwYXJzZWQgDQpjb250ZW50Pw0KDQpJIGNyZWF0ZWQg YW4gdXBkYXRlZCBleGFtcGxlWzFdIHdoZXJlIEkgY29udmVydGVkIHRoZSBTUUwgZnVuY3Rp b25zIHRvIA0KdXNlIHRoZSBzdGFuZGFyZCBzeW50YXggYW5kIEkgcmV0dXJuZWQgdGhlIHRh YmxlIG5hbWVzIHRvIGJlIHNjaGVtYSANCnVucXVhbGlmaWVkLiBUaGlzIHNlZW1lZCB0byB3 b3JrLCBidXQgSSByYW4gaW50byBhIHdlaXJkIGNhc2Ugd2l0aCB0aGlzIA0KZnVuY3Rpb246 DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHB1YmxpYy5jYWxlbmRhcl9tYW5hZ2Uo cm9vbV9pZCBpbnQsIA0KY2FsZW5kYXJfZGF0ZSBkYXRlKQ0KUkVUVVJOUyB2b2lkDQpMQU5H VUFHRSBTUUwNCkJFR0lOIEFUT01JQw0KICAgICBXSVRIIGRlbGV0ZV9jYWxlbmRhciBBUyAo DQogICAgICAgICBERUxFVEUgRlJPTSBjYWxlbmRhcg0KICAgICAgICAgV0hFUkUNCiAgICAg ICAgICAgICByb29tX2lkID0gJDEgQU5EDQogICAgICAgICAgICAgY2FsZW5kYXJfZGF0ZSA9 ICQyDQogICAgICkNCiAgICAgSU5TRVJUIElOVE8gY2FsZW5kYXIgKHJvb21faWQsIHN0YXR1 cywgY2FsZW5kYXJfZGF0ZSwgY2FsZW5kYXJfcmFuZ2UpDQogICAgIFNFTEVDVCAkMSwgYy5z dGF0dXMsICQyLCBjLmNhbGVuZGFyX3JhbmdlDQogICAgIEZST00gY2FsZW5kYXJfZ2VuZXJh dGVfY2FsZW5kYXIoJDEsIHRzdHpyYW5nZSgkMiwgJDIgKyAxKSkgYzsNCkVORDsNCg0KVGhp cyBwcm9kdWNlZCBhbiBlcnJvciBvbiB0aGUgc3Vic2NyaWJlciwgd2l0aCB0aGUgZm9sbG93 aW5nIG1lc3NhZ2U6DQoNCjIwMjMtMDItMTYgMjA6NTg6MjQuMDk2IFVUQyBbMjY4NjRdIEVS Uk9SOiAgbWlzc2luZyBGUk9NLWNsYXVzZSBlbnRyeSANCmZvciB0YWJsZSAiY2FsZW5kYXJf MSIgYXQgY2hhcmFjdGVyIDMyMg0KMjAyMy0wMi0xNiAyMDo1ODoyNC4wOTYgVVRDIFsyNjg2 NF0gQ09OVEVYVDogIHByb2Nlc3NpbmcgcmVtb3RlIGRhdGEgZm9yIA0KcmVwbGljYXRpb24g b3JpZ2luICJwZ18xODY1OCIgZHVyaW5nIG1lc3NhZ2UgdHlwZSAiRERMIiBpbiB0cmFuc2Fj dGlvbiANCjk4MCwgZmluaXNoZWQgYXQgMC9DMDk5QTdEOA0KMjAyMy0wMi0xNiAyMDo1ODoy NC4wOTYgVVRDIFsyNjg2NF0gU1RBVEVNRU5UOiAgQ1JFQVRFIE9SIFJFUExBQ0UgDQpGVU5D VElPTiBwdWJsaWMuY2FsZW5kYXJfbWFuYWdlICggSU4gcm9vbV9pZCBwZ19jYXRhbG9nLmlu dDQsIElOIA0KY2FsZW5kYXJfZGF0ZSBwZ19jYXRhbG9nLmRhdGUgKSBSRVRVUk5TIHBnX2Nh dGFsb2cudm9pZCBMQU5HVUFHRSBzcWwgDQpWT0xBVElMRSBQQVJBTExFTCBVTlNBRkUgQ0FM TEVEIE9OIE5VTEwgSU5QVVQgU0VDVVJJVFkgSU5WT0tFUiBDT1NUIDEwMCANCkJFR0lOIEFU T01JQw0KCSBXSVRIIGRlbGV0ZV9jYWxlbmRhciBBUyAoDQoJICAgICAgICAgIERFTEVURSBG Uk9NIHB1YmxpYy5jYWxlbmRhcg0KCSAgICAgICAgICAgV0hFUkUgKChjYWxlbmRhcl8xLnJv b21faWQgT1BFUkFUT1IocGdfY2F0YWxvZy49KSANCmNhbGVuZGFyX21hbmFnZS5yb29tX2lk KSBBTkQgKGNhbGVuZGFyXzEuY2FsZW5kYXJfZGF0ZSANCk9QRVJBVE9SKHBnX2NhdGFsb2cu PSkgY2FsZW5kYXJfbWFuYWdlLmNhbGVuZGFyX2RhdGUpKQ0KCSAgICAgICAgICkNCgkgIElO U0VSVCBJTlRPIHB1YmxpYy5jYWxlbmRhciAocm9vbV9pZCwgc3RhdHVzLCBjYWxlbmRhcl9k YXRlLCANCmNhbGVuZGFyX3JhbmdlKSAgU0VMRUNUIGNhbGVuZGFyX21hbmFnZS5yb29tX2lk LA0KCSAgICAgICAgICAgICBjLnN0YXR1cywNCgkgICAgICAgICAgICAgY2FsZW5kYXJfbWFu YWdlLmNhbGVuZGFyX2RhdGUsDQoJICAgICAgICAgICAgIGMuY2FsZW5kYXJfcmFuZ2UNCgkg ICAgICAgICAgICBGUk9NIA0KcHVibGljLmNhbGVuZGFyX2dlbmVyYXRlX2NhbGVuZGFyKGNh bGVuZGFyX21hbmFnZS5yb29tX2lkLCANCnBnX2NhdGFsb2cudHN0enJhbmdlKChjYWxlbmRh cl9tYW5hZ2UuY2FsZW5kYXJfZGF0ZSk6OnRpbWVzdGFtcCB3aXRoIA0KdGltZSB6b25lLCAo KGNhbGVuZGFyX21hbmFnZS5jYWxlbmRhcl9kYXRlIE9QRVJBVE9SKHBnX2NhdGFsb2cuKykg DQoxKSk6OnRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSkpIGMoc3RhdHVzLCBjYWxlbmRhcl9y YW5nZSk7DQoJRU5EDQoNClRoaXMgc2VlbWVkIHRvIGFkZCBhbiBhZGRpdGlvbmFsLCBpbmNv cnJlY3QgcmVmZXJlbmNlIHRvIHRoZSBvcmlnaW4gDQp0YWJsZSBmb3IgdGhlICJyb29tX2lk IiBhbmQgImNhbGVuZGFyX2RhdGUiIGF0dHJpYnV0ZXMgd2l0aGluIHRoZSBDVEUgb2YgDQp0 aGlzIGZ1bmN0aW9uLiBJIGRvbid0IGtub3cgaWYgdGhpcyBpcyBkaXJlY3RseSByZWxhdGVk IHRvIHRoZSBEREwgDQpyZXBsaWNhdGlvbiBwYXRjaCwgYnV0IHJlcG9ydGluZyBpdCBhcyBJ IHRyaWdnZXJlZCB0aGUgYmVoYXZpb3IgdGhyb3VnaCBpdC4NCg0KVGhhbmtzLA0KDQpKb25h dGhhbg0KDQpbMV0gaHR0cHM6Ly9naXN0LmdpdGh1Yi5jb20vamthdHovZmUyOTAwNmI3MjRm ZDZmMzJlZTg0OWE5NmRjMDE2MDgNCg0K --------------MMfgRzifaep48IBypDKhwVk0-- --------------0IW7Hc5ytlW6H4KLqKEDQldk Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmPumz4FAwAAAAAACgkQ8QSccp8cZSdn TQ/+Mm3E0em/0Ymd+WN/04GmNiqypJU17rkmAyfqerA6bbB6Mg1PIf0eDC0whZTOwzSTl9HYV7Tq E5aJHUGnxq8Q7JPLOCSV34wogTpZ4lR489hCpATnr57vKTIAEnUZL1nhGJOgKuJC0rIP7bjrU70N x+5PVZ7lHYFNr9CCzqg1RHQyv49fs/V3ScTeZNdHlcGWnd2daBRNICEZDQsl9t0lksF5UGxvQSuj oIweHk5U/Scps58XdQCTH8a5/Cbqs7QrHPhCbdppyXVaP57X+naU2rHocMjR2nUmscXGa8deqcPO t435TgJnAyoiN8UQDCvS3MQXCEE7L7PbqSjJNBc2DY2jjQHtSYtMHMZVlgjAuFqMVpYePn6E4dM9 /yuLWrb5S2y4K3AVhd/h0KS9vXf8D0ZWIqz95VmCu88kd4gQAP2uZh2Y84VOS64SaPdPqi43cDRa hLkV3QB336oEsRoOltZXgd6A9WWJPi0GAXLXy6ZwMpXe7LVbadDXBH6CLM/6Y3pygEw/0i0gyxWR 4+eJAuAw5gHsShCo+i6UnNZKMzfgWP1MmX2UZBNpvr284LkJTXVTAfgJE2IJ25WFfZv7W4jzC16z b3J77dyTwfYI4+6+U/dbhyR3ynUDOvbTK6HYlUCNEADFjoYR2YGaQoTBDEHk8csziLNRohmafXif rYk= =i+3j -----END PGP SIGNATURE----- --------------0IW7Hc5ytlW6H4KLqKEDQldk--