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 1nR7wN-0000Ve-LN for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Mar 2022 07:38:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nR7wL-0003JM-KU for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Mar 2022 07:37:57 +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 1nR7wL-0003JD-21 for pgsql-hackers@lists.postgresql.org; Mon, 07 Mar 2022 07:37:57 +0000 Received: from esa20.fujitsucc.c3s2.iphmx.com ([216.71.158.65]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nR7wI-0002fn-0q for pgsql-hackers@lists.postgresql.org; Mon, 07 Mar 2022 07:37:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1646638674; x=1678174674; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=C5k9/G+yeBDrLT1TnQtN71VDMBr8yQez77bp7DoRsZw=; b=Jy9DU1Q7OFd/YxPJppAcuC4pTB4plQimsct9Gs+ovNBNOI/LO8KMxQSh XNJVHfP/jfbY3Z7gkfIE/1cmHoNBoXGkoTua9ZYr7MNIaP2DEhJtFNoBP Xc4koMGN7mHzD5qeB+wTd5LehDackV1aS+tW6nS5yDb69P1wUwsVr7+fm dr1h0yxDe8YO0olCCKPPiFz44XTGR+oL8xyrTKLGahCfvHLCJIqyKk6eD 26RimHrAZzpPPNS66pFvui8PK7rrNgg7NbABSDPXYzf5EdLMUSOB912r3 NFcB1EIl106bMbU+ofewYNjaKsU2UmiR/K6wFlcN648T3fn87JqzJOE1y A==; X-IronPort-AV: E=McAfee;i="6200,9189,10278"; a="51130817" X-IronPort-AV: E=Sophos;i="5.90,161,1643641200"; d="scan'208";a="51130817" Received: from mail-tycjpn01lp2169.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.169]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 07 Mar 2022 16:37:50 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ZmAnugGLN4yqb0AfDO6cv2YeRSYw24mIN+DbuFumk3+ikZ5KfQ0Lhfm4McHCXfX9UP51ZAUanHcJtj9TmltJMHsW5YO8dXk3LcQjFqOX0gG7sjUScJXHgvkI7/JH3sS4CI+nq1dEW22J8tc1UcYDWQUdNguN1jJ3XtalXpPuPtoSXlJ7PWhxDqPr9T9lFRclzdxsFPo5mq1o5w6/eGT47nU0Hp8TKsd/5V/xdTt9jSXXAQzneOnub/4NISsa+sx9JfrP3ZaktJ3YOV3ssaHQDxu7MX1LuBwnqB5rCBiLEU8dDGAUXLsMQsKPV4n8DLqrXa+wGSomjri/dJCQpEEF1Q== 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=C5k9/G+yeBDrLT1TnQtN71VDMBr8yQez77bp7DoRsZw=; b=DOJ2theJtd53XCNseRkAJMmQxcdfp7TAg+UZKKUsfQGpFfH+aBm2MyEDPDkpNBxtx0EidgPyUGXaSRH1W0OFFTUJ58Kw0VmKGJy99Va7kCHpddTtC0uFpaSj+vzsfWcbGwnLnmVSfoB1vvUFW8SLgf9FMKmjNMm9CtWyf28zSXn3y21VPfG68N7mdyrxWOiWz+9nKxh/EicrIRMwIY4EjV4jLb+nTpnjz20W9adPLidsnuhWwZXQiG4xFqK+qkflbs//JRjXYg/f9qxVD3PkvH6a4mbe6ym7eECpEDpz7bzcfuM33ZG/O6+XygLo2j1Qs1aFhfN91qliTslZ+dZl8w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=C5k9/G+yeBDrLT1TnQtN71VDMBr8yQez77bp7DoRsZw=; b=kJB6V8SdnKFni3jS/7wT7j4E3o20SwCpggLbGNhlJBc7epO3neYmw6gtf0XlZinSv4Ygd5AXEcNzypIFIRkm7ds643faOq3zcSwNP66UuvWomhoy/Hq694cbZVgSVkZgMKNFNYw4aHjf/3WAtYj7ajTBjBC4zSIdjltsdlkXLHs= Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com (2603:1096:404:8056::13) by TYAPR01MB3374.jpnprd01.prod.outlook.com (2603:1096:404:c6::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5038.14; Mon, 7 Mar 2022 07:37:47 +0000 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::12a:7361:2fb3:2b32]) by TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::12a:7361:2fb3:2b32%7]) with mapi id 15.20.5038.026; Mon, 7 Mar 2022 07:37:47 +0000 From: "kuroda.hayato@fujitsu.com" To: 'vignesh C' , Peter Smith CC: PostgreSQL Hackers Subject: RE: Handle infinite recursion in logical replication setup Thread-Topic: Handle infinite recursion in logical replication setup Thread-Index: AQHYKH6ztA1JDNnSuE+/VNztFAHH2ayqRANggAILi4CABx7ZgIAABsGAgAAPJgCAABGUgIAAA3BA Date: Mon, 7 Mar 2022 07:37:46 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfRW5hYmxlZD10cnVlOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJh?= =?utf-8?B?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjItMDMtMDdUMDc6MzU6?= =?utf-8?B?NTVaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD05MDEwYzQ0MC1iMWY4LTQzYjIt?= =?utf-8?B?YmY1OC1kM2Q0ZWVjYWQ4ZDA7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?utf-8?B?MmFjLWFiNGQtM2IwZjRmZWNlMDUwX0NvbnRlbnRCaXRzPTA=?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 69fb5ac2-391c-4c35-35b1-08da000d5fee x-ms-traffictypediagnostic: TYAPR01MB3374:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: yV8j+HeUTBw278GrLc6n1tXVIJ38B7TDjbxXPUHm1xlYbP6KE13yxzzpGbHjzi4ls1FtGS0mDO9As7bY1XpKxQORnDlYMmqV3M7A5gIFOYnAoLoafuL5H66BeC+o5yNFMqmM9Gk1e0l5AffnkX19D2+lJOFO3Hz00o5X1VoFPmxql6ZK/pr0qHcvsoVe5iJr9pCRuoe0fBKKOQVLtq5d8MYpRw7rvlKDaUMdaPsfEqsdDSDZTHE5Vcc1Jv2HuKz9PxATnsbChsdEhDKdlSR9vadOF4X5xMypsOzIzvEhZjI27zcdxPbIXJwqqrc3afiG+6WTw5Tf7fgUA7JY5lDn6jdo+l5Aa/H62hLZtfYG2oWiZfKezq/CkJoA3v0F4GzdAvkHzwldkeFIUi3VqQNZRxsmxT6xx+39P2YKqBTc8QE2bmHqmJlWFaux6EqKlmeApKUWLTBYd6AgX9BMbBXci23naisQ9neV1hu3wvs1P0366pEK7vqGUXBeTA0IRI8dZMI5/eiXxUYcZB0VJPCQHnmLPnLct6pZ5k8v0HvudxQuRVEoRaKgYCUw4rXjFAaE9XZMfTsG5ruzUKWrwEubxQq3+hUPQcjGox8DVes5bZmGxapt4uLrFsEAqyJ/YIfY0MwAlcicTltiOl65wvbX7UhEuw9C6EIp40wCkjQ4LkYciulGFWMyPaeCkBoJAWWM7TCm/EbHRQTDmk96k2xFig== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYAPR01MB5866.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(186003)(26005)(76116006)(66946007)(508600001)(71200400001)(38070700005)(9686003)(33656002)(86362001)(6506007)(82960400001)(7696005)(2906002)(55016003)(122000001)(5660300002)(38100700002)(110136005)(52536014)(316002)(8936002)(4326008)(83380400001)(66556008)(4744005)(8676002)(66476007)(64756008)(66446008)(85182001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?UE1jSkRKdFFKVXZ4VWJzdzRlVUgzQjVVSDBlSmpYSU1XZWl1bk9pWHZvSXI2?= =?utf-8?B?MmVYQ1pGWU5KZ2lWNHZFamFmUm9pRFhWM0ZJSmlieHVJR05Kd1h1NnJ2SGZW?= =?utf-8?B?bHdjWWVOY1JBTzVMQUU2d0padnBWZjQwUVdnQ2NxVjRHQVZvdkxZNUw3OUxy?= =?utf-8?B?L1JYMXlJaTBmTnZSbzhaby9JR2IxTXRUUVVzNWEyaXVnbFdSdEEyRXRCb2R4?= =?utf-8?B?YUl0QVcxTWsvL09DOEVjZHhtUm1lYXN3d0RXQ0FDYURGdUtrYlRicXlrWG5J?= =?utf-8?B?WGFhbm4vUldOUXd4b1pMRWd0ZTRtUVB2MHFGY1dBMEplQ0Q4eVZjTC8xWmth?= =?utf-8?B?NW9VbHd6cE9zSVdXQTlTcVA2ZTVia3dicEVTZDdSdXlyTW9kcWpBbUp0djk1?= =?utf-8?B?QWpnQkNEaG5uNnBOa3BSNFcxZlY1ZFFYa0xtS25DUkpia282THFkMk13R1FR?= =?utf-8?B?cGdwY2trSkc3REh6WXdmT3VMR0pLcjB4cktlQkIwOGxidXV4a3NWV0h1ZDhG?= =?utf-8?B?QXlUYjFPbnhHa2RzSXpNQTErdGNjSUNNbXNrRGtxQ2VuRzg1T2kzcFZsbG5o?= =?utf-8?B?alZwRlNDV1hOcVZjYXY3b2V2ekt5bFVnWitVVHFPSHpJWlJSMUp5V3ZLUkN0?= =?utf-8?B?RTFsdWdBZlNUNTQ3RnFXVlRkTWoxUnVkSk4xUjVyaGhST0RCQkdJRm9nOFdX?= =?utf-8?B?YjhiTGhhNDVHN0VVWHFFUVpGNy9HY3lpaC9Jd3ZzbXVDR0ZoaGUrNHBGWE1B?= =?utf-8?B?dkNwOEJBQ2d5dW9SaFVyWDMxcXhjRi85UVluc1Q0ZU5wRjhRbnhqQXFqM2lU?= =?utf-8?B?WTJEVkp6dFZoVFJGQnZ5UDNyc3lIWE1pYWFlN3dUYWxrR1VaWkFqU2dSZ25j?= =?utf-8?B?U0ZPTjU1YVdhZVNWWm00dGMzeUU2eFZ4Y0J4TXdJakVIOTVVQmlNbkxOWFNG?= =?utf-8?B?bUdZd2hNTWx2dGRlT05xZVl2V3lrWElKbTZlUkk1Y3VBaVc5Rmg1a2FLTHBT?= =?utf-8?B?ZTNTTGZ6a0hKZWR3ODFjM2d3VEdvcXE2b3Fjck02ODRYeUwwd0ZHR0JrZnJk?= =?utf-8?B?U2ZrZGFVU3lpUHhxbnpaVkZnOXdWWWRoWGowNnI1THVZRmpPUXdHOSsyeDh3?= =?utf-8?B?YnN0dkNLYjhBR3ZHSkZDYVQ5SEtaVm1TZXpZSlNaZnRWZllNaUV2N0dRUW5W?= =?utf-8?B?UW1aL3FiMkwzSC9MVXQ2RnJmSWtXUjlCMTlmZ25wSVJXRCt4WWxURW5EaUJ2?= =?utf-8?B?dG9FM0dMengwMGFycEw5S2x5ekVSeER4OGNOQnNna0ZIYnlMTkxRSTB6MWVk?= =?utf-8?B?VnFlYVQ5L3VuM2dnbHFFTjM5QlRoR05ZUTFWZHRXakpveDMrSFdvcG1kS01C?= =?utf-8?B?R3RwemVHMFl0UU5XL1lqcXh5Z1AwR2d6aUxnU2dwcGpvTkhnOEpUS2h4SlRQ?= =?utf-8?B?aUdQU29GWHF4NDZKN05ZL3piOXpJTVo4OTN1R21VcFVSZW9kSE1odXUzUWJL?= =?utf-8?B?V1A3WlI5cUdPRWpQZXpwZFhYbk5IVUM2cTFuK2pVMG12NmlZZzZYcHpEeCtS?= =?utf-8?B?SGtzVEc3TkI1em1Ub3A3QnZFcTVzWW56RjBTc0cxNlMycXpkVzJzTktucU0w?= =?utf-8?B?RllPZzQxNGVXcXVDemx1WlNwRUZlY1VwR1QwNWpmYVFheXROK3dlTjFwQlZI?= =?utf-8?B?SXFaUnovL3dHUzhqT0hma2dpcnJ1VEZLWGxNS2dqWllKQk1meVpjYmt1Myt1?= =?utf-8?B?Q3A0cVJHOG83L21CdjlpRGNoWjdwQXZwZk13WlhvSFNPaHJRSm84enZWSmpm?= =?utf-8?B?elJvN1RhZHJKQU9DS2kvZnl2b1NhaURkeEVxRzROVEdqVWhlTkxYcXV6VWJm?= =?utf-8?B?amVGMGppVmFOTVBQOUVyWjQvVDNkU2NmWm1jR1pUcVJsUW9kNk5ZdG1GVDF2?= =?utf-8?B?ZFdWM25vZUI4anhtSGx5L0FmR0QySmdLc2pLdUtTZjUrSWxQYlh3WjQvVFZC?= =?utf-8?B?SWZyWmgrMEU0ZTY2NHdDZXFhOVNUV0Z6SUU4c0MvQWRMSllVS3o3dTBNZ284?= =?utf-8?B?aG5JclZOekZ6OUhBNUdubGkvVlc5SnAvNUlnN1VHOHMrcXFtd1JpOVhTTlEy?= =?utf-8?B?Rzg1a044SG16Q0xNMEk5VThqbi80NndzSEdLREtMUWlqM3hud1BZWG5hU0l6?= =?utf-8?B?MjJMQlN1V25qQWFBWWhyeDl4N0pnUWE3V25Jd3ZVdnZUNVpVV1p1YjI2djZZ?= =?utf-8?B?WER2dkpINnJiWkExRFRNSlV1UkRRPT0=?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYAPR01MB5866.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 69fb5ac2-391c-4c35-35b1-08da000d5fee X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Mar 2022 07:37:46.9262 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: TJMp7Z9NiwvnxVhTs+9hJFuTyv/R9IshqOevDVvKmbANC/rFAPrm3V4wIwDzQmKg62gIqkJm1hMt4OsUsvtHEQIfsA/zKtTdv2CHK1DQXVE= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB3374 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBWaWduZXNoLA0KDQo+IEkgZmVsdCBjaGFuZ2luZyBvbmx5X2xvY2FsIG9wdGlvbiBtaWdo dCBiZSB1c2VmdWwgZm9yIHRoZSB1c2VyIHdoaWxlDQo+IG1vZGlmeWluZyB0aGUgc3Vic2NyaXB0 aW9uIGxpa2Ugc2V0dGluZyBpdCB3aXRoIGEgZGlmZmVyZW50IHNldCBvZg0KPiBwdWJsaWNhdGlv bnMuIENoYW5nZXMgZm9yIHRoaXMgYXJlIGluY2x1ZGVkIGluIHRoZSB2MiBwYXRjaCBhdHRhY2hl ZA0KPiBhdCBbMV0uDQoNCisxLCB0aGFua3MuIEknbGwgcG9zdCBpZiBJIG5vdGljZSBzb21ldGhp bmcgdG8gc2F5Lg0KDQo+IFNoYWxsIHdlIGdldCBhIGZldyBvcGluaW9ucyBvbiB0aGlzIGFuZCB0 YWtlIGl0IGluIHRoYXQgZGlyZWN0aW9uPw0KDQpJIHByZWZlciBzdWJzY3JpYmVyLW9wdGlvbiwg YnV0IEkgYWxzbyB0aGluayBib3RoIGFyZSByZWFzb25hYmxlLg0KKzEgYWJvdXQgYXNraW5nIG90 aGVyIHJldmlld2Vycy4NCg0KQmVzdCBSZWdhcmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVKSVRTVSBM SU1JVEVEDQoNCg==