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 1nWtFe-0001Db-8r for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Mar 2022 05:09:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWtFb-0006FW-T0 for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Mar 2022 05:09: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 1nWtFa-0006ED-J0 for pgsql-hackers@lists.postgresql.org; Wed, 23 Mar 2022 05:09:39 +0000 Received: from mail-sy4aus01olkn2163.outbound.protection.outlook.com ([40.92.62.163] helo=AUS01-SY4-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWtFM-0006Aq-8G for pgsql-hackers@lists.postgresql.org; Wed, 23 Mar 2022 05:09:37 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=IjVhzX+M+tkGadvz95AevNZvrbrWYPv2x+N3CyKeQlNqf/PFHWgcOnQ7q2vGKRPIz6G3ihwj8gouKiXzwIP0ZZ/UVGQW2qqwOfgQZWMfbdF4iNFhfAJo2SNnOKO2rkb7DM0Nskqp7QO+BOLNhQmoxB2HrOT+qMRuU8ke9GWfF8lQ/qzChVU5E6vhj13YGcZjhK1EaO4TIPEcRq6cbin14tfwUwgY+JuiY5qVNl56VoixW6ADepZtPze9PFm2lVSKg/g0BQ6tF5XnFj4Kx3h6N0AGYCyaDwVFfx2RuUlUC6L4wMMd7/X2WtmM5EIvagp88B9fPIIUVIzDtYdG+MAfxg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Goryd1yN4zMy0/REeHHVps+nYi6uMRmF7Wn/eyqgRt4=; b=C6uYL8m7XfzhDe5+vA+MkGGC1Bm6RdPF2KTqTS0P9yfs1me2RlqQ85yvMFAlCnzgIdt+Pti32NAghFsCTxT0YrXk6Ddh/6JoVoWbXUYqdD+QjB9y9HGx/aWLQJIqFrAlexjAvw2OLcvwei9eofxEf3ql3xA5eW7ez+nqz2WcbYk+8KZY97L/NgUhu8X0Lt/gkZTO0RFbw78hd2MxMBXPTV7M29qrX6aN0JeGmfsUTfXStm/gs6v7arogsnVbuGgnT6EPis2k0aRNHQ2q/uoc05VP4Dgzz2p9UG3SdEZcyX+sB3OG9ZHh20h3Zi2OuP2WQe6slPlEEQepNZlPIrLttw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Goryd1yN4zMy0/REeHHVps+nYi6uMRmF7Wn/eyqgRt4=; b=gqyIKKNSqjcdsd1D7K+XLu6iLwq1C/4r/LSkdpt0j9WkZldrRpupHDjchIsXDGKYY995CKWTpa7uiGVSk0WTusf4Gg/CrrWEZdEq7DnviYJ+tRbF5pllpQuvv1CFVTZVOGXt7SyY9YS5azbv+ol/D1FmY7HKnogWtNMIBZcIjUA6FJ4NOtdgK+zvcUjP0ZPfuA7wf4mObaIjFcGEaGw40qvVEOqeoR3D7hcEYLpIV2vycWvpqDRh+XVAoOBkOq/rAcRAFjkgfvGB2vFLqKA3xEV7kcM9ZoDWx+6OnLOi06zlYhxBcZmQzzYqC9fk2AR/0iqDfiLn1nRfgWxjrg9M3Q== Received: from MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:c3::12) by MEYP282MB1494.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:ba::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5081.17; Wed, 23 Mar 2022 05:09:17 +0000 Received: from MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM ([fe80::d98e:eb30:1192:e1d2]) by MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM ([fe80::d98e:eb30:1192:e1d2%7]) with mapi id 15.20.5081.023; Wed, 23 Mar 2022 05:09:17 +0000 References: <202203162206.7spggyktx63e@alvherre.pgsql> User-agent: mu4e 1.4.14; emacs 27.1 From: Japin Li To: Zheng Li Cc: Alvaro Herrera , Dilip Kumar , rajesh.rs0541@gmail.com, PostgreSQL Hackers Subject: Re: Support logical replication of DDLs In-reply-to: Date: Wed, 23 Mar 2022 13:09:10 +0800 Message-ID: Content-Type: multipart/mixed; boundary="=-=-=" X-TMN: [KLPCR0N3TDcXH4EEbNc+UMqSP3buk4Ea] X-ClientProxiedBy: SG2PR01CA0193.apcprd01.prod.exchangelabs.com (2603:1096:4:189::18) To MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:c3::12) X-Microsoft-Original-Message-ID: MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: ce6b49df-5e3e-44ec-c2ce-08da0c8b471e X-MS-TrafficTypeDiagnostic: MEYP282MB1494:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: PQCqydq9pPbuisDeumTTGLdl7DhpGCBDm4GzHZPBH2Pakq8JmcQrV4CCUxvL5fBeZMu93RUUeYDpru4FOmEVumaXZiGx0O1hfKuT4bAPM6KipPC9bKiYGVSRPpE/ivSagIqOMdB/0+tRGHHHKbAIacpp9swFnWmPrJ9l/ywAiGdROawypJgjuvr6eHX/sl+SoaTKFMWka8jH/C/caLFQWZZZxyJi48NHuIccgLkkKRD6RPnc5i/snmhlB4W07X+WEuzBT/Xwwwpa+weXsVFsqfeRlVxO7BawyUlHayLGtGsM2QpuY/JMHcslG819J9dacZ2PCXv2dlQTxC1+2+p+dtVGFDWhvvTdq5GP0qCFZyNSTImMzbJXPisr82f160Ti5xoXRYA22uhugnnmGUlOJPFyGFzV/8+Y7eQRDaegSgRsUzHjLkRV3KFNLQ0GuhrPqogJxltwbHIw+v8Zx8ZnxRjuH9qkU3vc8/F0/UUTaXbKeG7DFal5hdvL5BSYE6A72oDhv9a3n+5sY9D4kbrium+VZvtLH22NRfXN0uCg1HGDl91AzStPC1KshJKuLJoXpXxIrZypLeJ7mI2Y/GXGIwzLULuX3x+qz0Hu3978pFPd90xwL9SPt8ZdKiIihvfX X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?GZX+dcRebcH7g9GuFyV3XNQRb8WIL/BPNzy93PZCc63PsqS1X8N0gGFo7EhQ?= =?us-ascii?Q?TVRb5OjLJlaRns0AVO0GKRxFQNYjqgscqYggTnL2cMPXbbNDbPrcXFkq5xup?= =?us-ascii?Q?fZkZOrC90puI/ta6/mmqavRIHzu9rO6haotm8uVdrHNlp+28qPQHo1xmldgQ?= =?us-ascii?Q?M+4WOywukULHxmsyf6Zf0HUhLrfJGxJU68cphhqFtNRcMA0P1IIVJS3QYmfS?= =?us-ascii?Q?35Qrk1MgPLNRpT+MG+ix7K2z/2rzh90hGNMZcA58vkYNlOKR4VKRWGW4EPKQ?= =?us-ascii?Q?kRRxIcnfeL7XOZTjO/iv2Wmnn2vglFVWsTfgSDn1hjng1auceBgVHVdhTykQ?= =?us-ascii?Q?rYNWPW+L6UeWYB2+68MMRqHMbmxwssyDZ2owT10K9cUIv7nYHEhST65dE6co?= =?us-ascii?Q?CN1vKf5ZS2/AS/aD8CVgqHhgzlhWmdd1jngiCehMK8F8K0bL+tg+xE0R20NR?= =?us-ascii?Q?P1wdvDpLLLIPYljLBxF3SoyA9z1/LtJptmSIUKimZG49mAasl7P3Rxv0WekF?= =?us-ascii?Q?7PdARIz2xnNR7M+UC3FjQYZVY4v0rVf527LdU9m2/7mAXJBbjyVTMxreOn45?= =?us-ascii?Q?Mv2Hg/99vb0sxjKTRcvVXDLOk4TnDBWqDtzPuBtFVVrTSirFyV8BMkCzjUMg?= =?us-ascii?Q?OnnjjPZJ57YrngbouUNB3AstvDFmx/TarjHKsF5F9Bqb4tw88HVHF1NeUXdd?= =?us-ascii?Q?gECsMoXzHlDL5iS1CoJuliqw9AEhS1dYZzeLkyr1IPv5v6JzuU+7hQKd9Poj?= =?us-ascii?Q?IJlC9a7NWyiIpniChTnNNSZEr/CMGjF17yeBhTY6UFtdoHtHz0vE568CSZF6?= =?us-ascii?Q?gZPwSUcR5fkDiMEe4zJ1Ca+AFm099CFsHHV4LNIXpSa2tYFKjc0e6crQzLlf?= =?us-ascii?Q?W4Q9ODWW+lp0UroCr81ZEdZoBmFclJePL5f0RUXDeuD1FayBIhoqk18zIrD3?= =?us-ascii?Q?Y/QiNRTvUOfw5BcyQPxu+NodG5FXT63NVLm7Kzp2e2wOYe7yy6NloAETZqZE?= =?us-ascii?Q?PdlQPamcsbHJMWKBt/Pmdi2zyCr4XYbMe9QWnhY53kLFbejsvXPpw0BrFrwp?= =?us-ascii?Q?owxEciDeyEK8OnVIHISi5jC5y+12HWOp35N5Ru3cyXOpuSdzQqMfo7d2q9IQ?= =?us-ascii?Q?45LAVudebXd8CyY7wZUlXtvWNT4DerLxvw=3D=3D?= X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: ce6b49df-5e3e-44ec-c2ce-08da0c8b471e X-MS-Exchange-CrossTenant-AuthSource: MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 23 Mar 2022 05:09:17.7667 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: MEYP282MB1494 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-=-= Content-Type: text/plain On Tue, 22 Mar 2022 at 04:56, Zheng Li wrote: > Hi Japin, > >> You should use a different user that has different length from your current one. >> For example: >> >> px@localhost$ make check-world > > This is fixed in the latest commit: > https://github.com/zli236/postgres/commits/ddl_replication > Thanks for fixing this. I rebase the patchset on current master (383f222119) and attach here for further review. -- Regrads, Japin Li. ChengDu WenWu Information Technology Co.,Ltd. --=-=-= Content-Type: text/x-patch Content-Disposition: attachment; filename=v3-0001-Define-DDL-replication-levels-via-the-CREATE-PUBL.patch