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 1pShS0-0008LD-Kg for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Feb 2023 16:49:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pShR1-000413-Gf for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Feb 2023 16:48:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pShR0-00040u-UO for pgsql-hackers@lists.postgresql.org; Thu, 16 Feb 2023 16:48:39 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pShQx-0000Nm-DZ for pgsql-hackers@lists.postgresql.org; Thu, 16 Feb 2023 16:48:37 +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:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=I9YJKYnMQXSq0dZeFZFT8k3Gkkos8uhZnUWhG1j5IFI=; b=joMKTop/3G/1YrQqUdASjEFfi3 Oys1MpERqJIhHGS1EZmB+OIFDxeEL03xRiLdmuxKvo53lDg6faRPaN6HonM9qfkc90ZsV520hl+JP NANHLL5HPq9kcJ8XcEJ8bzcN8WtxPURZc5yGtyTVp0Ye6uT/qOuUC9stvHEU4qwBmGN6w9nWUkYnc IICwZ2Y8Fyp5srvDsymH0RkG1kxXF9Xvm2CwsXvIqi61wtV6RrN+1Cjf9UnJlFXUouUacmGZId3+v zgdcQ/kWA27a9KIkD/OiOEmjT0kWsnr2CcjDuOPeYiX3z/qmQIElo8C/Jyl35eiHJ7wQPX9gZGKzi GBX3gWPQ==; 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 1pShQo-0003JT-QH; Thu, 16 Feb 2023 16:48:29 +0000 Message-ID: <263bea1c-a897-417d-3765-ba6e1e24711e@postgresql.org> Date: Thu, 16 Feb 2023 11:48:22 -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 To: "houzj.fnst@fujitsu.com" , Amit Kapila , Ajin Cherian Cc: Peter Smith , vignesh C , Zheng Li , li jie , Dilip Kumar , Alvaro Herrera , Masahiko Sawada , Japin Li , rajesh singarapu , PostgreSQL Hackers References: From: "Jonathan S. Katz" Subject: Re: Support logical replication of DDLs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------KT1SjcTjEFpLmr9ugfwF90km" 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) --------------KT1SjcTjEFpLmr9ugfwF90km Content-Type: multipart/mixed; boundary="------------BjnNPbtAVyaJ0zqqW2hanCIo"; protected-headers="v1" From: "Jonathan S. Katz" To: "houzj.fnst@fujitsu.com" , Amit Kapila , Ajin Cherian Cc: Peter Smith , vignesh C , Zheng Li , li jie , Dilip Kumar , Alvaro Herrera , Masahiko Sawada , Japin Li , rajesh singarapu , PostgreSQL Hackers Message-ID: <263bea1c-a897-417d-3765-ba6e1e24711e@postgresql.org> Subject: Re: Support logical replication of DDLs References: In-Reply-To: --------------BjnNPbtAVyaJ0zqqW2hanCIo Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGksDQoNCk9uIDIvMTQvMjMgMTA6MDEgUE0sIGhvdXpqLmZuc3RAZnVqaXRzdS5jb20gd3Jv dGU6DQoNCj4gSGVyZSBpcyB0aGUgbmV3IHZlcnNpb24gcGF0Y2ggd2hpY2ggYWRkcmVzc2Vk IGFib3ZlIGNvbW1lbnRzLg0KPiBJIGFsc28gZml4ZWQgYSBidWcgZm9yIHRoZSBkZXBhcnNp bmcgb2YgQ1JFQVRFIFJVTEUgdGhhdCBpdCBkaWRuJ3QgYWRkDQo+IHBhcmVudGhlc2VzIGZv ciBydWxlIGFjdGlvbiBsaXN0Lg0KDQpJIHN0YXJ0ZWQgdGVzdGluZyB0aGlzIGNoYW5nZSBz ZXQgZnJvbSB0aGlzIHBhdGNoLiBJJ20gZG9pbmcgYSBtaXggb2YgDQpoYXBweSBwYXRoLCAi bWFraW5nIG1pc3Rha2VzIiBwYXRoLCBhbmQgInJlYWwgd29ybGQiIHRlc3RpbmcsIGFuZCAN CnRlc3RpbmcgdGhpcyBib3RoIHdpdGggdW5pZGlyZWN0aW9uYWwgYW5kICJvcmlnaW49bm9u ZSIgcmVwbGljYXRpb24uDQoNCkkgd2FudGVkIHRvIHJlcG9ydCBhbiBpc3N1ZSBJIGNhbWUg dXAgd2l0aCB1c2luZyBvbmUgb2YgbXkgcmVhbCB3b3JsZCANCmNhc2VzLiBJIGhhZCBwcmV2 aW91c2x5IGJ1aWx0IGEgZGVtbyBzY2hlZHVsaW5nIGFwcCB0byBkZW1vbnN0cmF0ZSANCnNl dmVyYWwgZmVhdHVyZXMgb2YgUG9zdGdyZVNRTCB0byBoZWxwIHdpdGggdmFyaW91cyBraW5k cyBvZiBkYXRhIA0Kc3luY2hyb25pemF0aW9uWzFdLiBUaGUgZmlyc3QgZXhhbXBsZSB1c2Vz IGEgc2VyaWVzIG9mIGZ1bmN0aW9ucyBhbmQgDQp0cmlnZ2Vyc1syXSB0byBrZWVwIGEgY2Fs ZW5kYXIgdGFibGUgdXAtdG8tZGF0ZS4NCg0KSSBzZXQgdXAgYW4gZXhwZXJpbWVudCBhcyBz dWNoOg0KDQoxLiBDcmVhdGUgdHdvIGRpZmZlcmVudCBjbHVzdGVycy4gSW4gZWFjaCBjbHVz dGVyLCBjcmVhdGUgYSBEQg0KMi4gT24gQ2x1c3RlciAxLCBydW46DQoNCkNSRUFURSBQVUJM SUNBVElPTiBkZGwgRk9SIEFMTCBUQUJMRVMgV0lUSCAoZGRsPSdhbGwnKTsNCg0KMy4gT24g Q2x1c3RlciAyLCBydW46DQoNCkNSRUFURSBTVUJTQ1JJUFRJT04gZGRsIENPTk5FQ1RJT04g JycgUFVCTElDQVRJT04gZGRsOw0KDQo0LiBPbiBDbHVzdGVyIDEsIHJ1biB0aGUgY29tbWFu ZHMgaW4gWzJdLiBOb3RlIHRoYXQgSSByZXByb2R1Y2VkIHRoZSANCmVycm9yIGJvdGggYnkg cnVubmluZyB0aGUgY29tbWFuZHMgaW5kaXZpZHVhbGx5IGFuZCBhcyBwYXJ0IG9mIGEgc2lu Z2xlIA0KdHJhbnNhY3Rpb24uDQoNCjUuIFRoZSB0cmFuc2FjdGlvbnMgKG9yIHNpbmdsZSB0 cmFuc2FjdGlvbikgY29tcGxldGVzIHN1Y2Nlc3NmdWxseSBvbiANCkNsdXN0ZXIgMQ0KDQo1 LiBDbHVzdGVyIDIgcmVwb3J0cyB0aGUgZm9sbG93aW5nIGVycm9yOg0KDQoNCjIwMjMtMDIt MTYgMTY6MTE6MTAuNTM3IFVUQyBbMjUyMDddIExPRzogIGxvZ2ljYWwgcmVwbGljYXRpb24g YXBwbHkgDQp3b3JrZXIgZm9yIHN1YnNjcmlwdGlvbiAiZGRsIiBoYXMgc3RhcnRlZA0KMjAy My0wMi0xNiAxNjoxMToxMC41NzAgVVRDIFsyNTIwN10gRVJST1I6ICByZWxhdGlvbiAiYXZh aWxhYmlsaXR5IiBkb2VzIA0Kbm90IGV4aXN0IGF0IGNoYXJhY3RlciAyNzkNCjIwMjMtMDIt MTYgMTY6MTE6MTAuNTcwIFVUQyBbMjUyMDddIENPTlRFWFQ6ICBwcm9jZXNzaW5nIHJlbW90 ZSBkYXRhIGZvciANCnJlcGxpY2F0aW9uIG9yaWdpbiAicGdfMTY3MzMiIGR1cmluZyBtZXNz YWdlIHR5cGUgIkRETCIgaW4gdHJhbnNhY3Rpb24gDQo4OTAsIGZpbmlzaGVkIGF0IDAvQkYy OThDQzANCjIwMjMtMDItMTYgMTY6MTE6MTAuNTcwIFVUQyBbMjUyMDddIFNUQVRFTUVOVDog IENSRUFURSBPUiBSRVBMQUNFIA0KRlVOQ1RJT04gcHVibGljLmF2YWlsYWJpbGl0eV9ydWxl X2J1bGtfaW5zZXJ0ICggSU4gYXZhaWxhYmlsaXR5X3J1bGUgDQpwdWJsaWMuYXZhaWxhYmls aXR5X3J1bGUsIElOIGRheV9vZl93ZWVrIHBnX2NhdGFsb2cuaW50NCApIFJFVFVSTlMgDQpw Z19jYXRhbG9nLnZvaWQgTEFOR1VBR0Ugc3FsIFZPTEFUSUxFIFBBUkFMTEVMIFVOU0FGRSBD QUxMRUQgT04gTlVMTCANCklOUFVUIFNFQ1VSSVRZIElOVk9LRVIgQ09TVCAxMDAgQVMgJF8k DQoJICAgIElOU0VSVCBJTlRPIGF2YWlsYWJpbGl0eSAoDQoJICAgICAgICByb29tX2lkLA0K CSAgICAgICAgYXZhaWxhYmlsaXR5X3J1bGVfaWQsDQoJICAgICAgICBhdmFpbGFibGVfZGF0 ZSwNCgkgICAgICAgIGF2YWlsYWJsZV9yYW5nZQ0KCSAgICApDQoJICAgIFNFTEVDVA0KCSAg ICAgICAgJDEucm9vbV9pZCwNCgkgICAgICAgICQxLmlkLA0KCSAgICAgICAgYXZhaWxhYmxl X2RhdGU6OmRhdGUgKyAkMiAtIDEsDQoJICAgICAgICB0c3R6cmFuZ2UoDQoJICAgICAgICAg ICAgLyoqIHN0YXJ0IG9mIHJhbmdlICovDQoJICAgICAgICAgICAgKGF2YWlsYWJsZV9kYXRl OjpkYXRlICsgJDIgLSAxKSArICQxLnN0YXJ0X3RpbWUsDQoJICAgICAgICAgICAgLyoqIGVu ZCBvZiByYW5nZSAqLw0KCSAgICAgICAgICAgIC8qKiBjaGVjayBpZiB0aGVyZSBpcyBhIHRp bWUgd3JhcGFyb3VuZCwgaWYgc28sIGluY3JlbWVudCANCmJ5IGEgZGF5ICovDQoJICAgICAg ICAgICAgQ0FTRSAkMS5lbmRfdGltZSA8PSAkMS5zdGFydF90aW1lDQoJICAgICAgICAgICAg ICAgIFdIRU4gVFJVRSBUSEVOIChhdmFpbGFibGVfZGF0ZTo6ZGF0ZSArICQyKSArICQxLmVu ZF90aW1lDQoJICAgICAgICAgICAgICAgIEVMU0UgKGF2YWlsYWJsZV9kYXRlOjpkYXRlICsg JDIgLSAxKSArICQxLmVuZF90aW1lDQoJICAgICAgICAgICAgRU5EDQoJICAgICAgICApDQoJ ICAgIEZST00NCgkgICAgICAgIGdlbmVyYXRlX3NlcmllcygNCgkgICAgICAgICAgICBkYXRl X3RydW5jKCd3ZWVrJywgQ1VSUkVOVF9EQVRFKSwNCgkgICAgICAgICAgICBkYXRlX3RydW5j KCd3ZWVrJywgQ1VSUkVOVF9EQVRFKSArIA0KKCQxLmdlbmVyYXRlX3dlZWtzX2ludG9fZnV0 dXJlOjp0ZXh0IHx8ICcgd2Vla3MnKTo6aW50ZXJ2YWwsDQoJICAgICAgICAgICAgJzEgd2Vl ayc6OmludGVydmFsDQoJICAgICAgICApIGF2YWlsYWJsZV9kYXRlOw0KCSRfJA0KMjAyMy0w Mi0xNiAxNjoxMToxMC41NzMgVVRDIFsxNTM0OF0gTE9HOiAgYmFja2dyb3VuZCB3b3JrZXIg ImxvZ2ljYWwgDQpyZXBsaWNhdGlvbiB3b3JrZXIiIChQSUQgMjUyMDcpIGV4aXRlZCB3aXRo IGV4aXQgY29kZSAxDQoNCkkgYXR0ZW1wdGVkIHRoaXMgd2l0aCBib3RoIGFzeW5jIGFuZCBz eW5jIGxvZ2ljYWwgcmVwbGljYXRpb24uIEluIHN5bmMgDQptb2RlLCB0aGUgcHVibGlzaGVy IGhhbmdzIGFuZCBpcyB1bmFibGUgdG8gYWNjZXB0IGFueSBtb3JlIHdyaXRlcy4NCg0KV2hl biBJIHdlbnQgaW4gYW5kIGV4cGxpY2l0bHkgc2NoZW1hIHF1YWxpZmllZCB0aGUgdGFibGVz IGluIHRoZSANCmZ1bmN0aW9uc1szXSwgdGhlIGV4YW1wbGUgZXhlY3V0ZWQgc3VjY2Vzc2Z1 bGx5Lg0KDQpNeSBoaWdoIGxldmVsIGd1ZXNzIHdpdGhvdXQgbG9va2luZyBhdCB0aGUgY29k ZSBpcyB0aGF0IHRoZSBhcHBseSB3b3JrZXIgDQppcyBub3QgYXdhcmUgb2YgdGhlIHNlYXJj aF9wYXRoIHRvIHVzZSB3aGVuIHByb2Nlc3NpbmcgZnVuY3Rpb25zIGR1cmluZyANCmNyZWF0 aW9uLiBQcm92aWRlZCB0aGF0IHRoZSBwdWJsaXNoZXIvc3Vic2NyaWJlciBlbnZpcm9ubWVu dHMgYXJlIA0Kc2ltaWxhciAoaWYgbm90IGlkZW50aWNhbCksIEkgd291bGQgZXhwZWN0IHRo YXQgaWYgdGhlIGZ1bmN0aW9uIGNyZWF0ZSANCnN1Y2NlZWRzIG9uIHRoZSBwdWJsaXNoZXIs IGl0IHNob3VsZCBhbHNvIHN1Y2NlZWQgb24gdGhlIHN1YnNjcmliZXIuDQoNClRoYW5rcywN Cg0KSm9uYXRoYW4NCg0KWzFdIGh0dHBzOi8vZ2l0aHViLmNvbS9DcnVuY2h5RGF0YS9wb3N0 Z3Jlcy1yZWFsdGltZS1kZW1vDQpbMl0gDQpodHRwczovL2dpdGh1Yi5jb20vQ3J1bmNoeURh dGEvcG9zdGdyZXMtcmVhbHRpbWUtZGVtby9ibG9iL21haW4vZXhhbXBsZXMvZGVtby9kZW1v MS5zcWwNClszXSBodHRwczovL2dpc3QuZ2l0aHViLmNvbS9qa2F0ei81NjU1YzEwZGExYTRj ODY5MTA5NGU5NTFlYTA3YjAzNg0K --------------BjnNPbtAVyaJ0zqqW2hanCIo-- --------------KT1SjcTjEFpLmr9ugfwF90km 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/x8QSccp8cZScFAmPuXlYFAwAAAAAACgkQ8QSccp8cZSd8 Sg//RSsMb1SLRwiYhT+tYrHdm0ouVr6Vgxd4KpSn14p9kyBs8odjf9cC4hxbc2X2tWsjEjAkMROO pwOQIDG2njN+COx+AmfCHmx5EXoyH5jtKy5pnl8g+Wc+w+YnGk7CzyrLRv6OlSbTSGtUZOxZNFTV QqVE1mpWL+92IX+VC4DEW/48p0KwzDP0paXtAQaMYtTQsXsfV3eH94jh47H9PXrmr6gBkoM6P8E3 pkC1X1bi+oblTxqqHB/WMeRsjFNe6ZGKfcXkU3AqQPJLG2O5tC1MeKSMQiOUwLN53zbLcrgNMZuE 75MJqOj2v0ELZoBZLPJWUfX4OS3AMJdyEq+jn8RH+T/66tnNp5PMxzDbs0yZpitgHjsPwA6fK2X4 N32ACrWoet/Oro5XquQPXqhD6Hi42Vd5T/dGH3zw3SF4mnZvZEb4mFKCJpujkJnGnKtME0qRFRoD nHH9IbAcDy6+O3G2yuGxm8J5zbMfg7KjDpgY/ASlQalyv+m8/D+Ch5xxAxnVfSLSC+HRNov52sS/ xwU4179d3+jCAeB1YeVjyjB2BSMPwlWAW3HoXCR4eGB5wDSms/IiBQvtgtPu3CYR06wdrkhKnD9r Npiq5c79NxPjOr8KJFpgH8kjq743/KwK2tO/E6tKd3W0rBVLF9PGHzwwA5GTvptLFYjjoYEe8WI+ jv8= =6ru9 -----END PGP SIGNATURE----- --------------KT1SjcTjEFpLmr9ugfwF90km--