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 1pbfnp-0000be-04 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Mar 2023 10:53:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pbfnn-0001Kt-S8 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Mar 2023 10:53:15 +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 1pbfnn-0001Kk-D7 for pgsql-hackers@lists.postgresql.org; Mon, 13 Mar 2023 10:53:15 +0000 Received: from esa9.fujitsucc.c3s2.iphmx.com ([68.232.159.90]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pbfnk-0003N7-FJ for pgsql-hackers@lists.postgresql.org; Mon, 13 Mar 2023 10:53:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1678704792; x=1710240792; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=gi9Hz8IU8GgkHuEL8cLfkN27tVRfT7IA8ZkrCRQhF00=; b=rGzTDDe5ZrEPy7gEOv+kRRG80DSImpjvy0EPwUTFACn1bWuTd9merobw DXRXBvEmQNzNJC2pPQ1LRQ4BCJbMFtl7943AKUAVt9F3PZHgUOXrpCSgb irR94oI4sTZa/gBldN0mu98YXkJACorHlrlmnapXmFMLK8aFRl/GBGdIJ 63nk2kCsyIaOsqMc6K/5hTLk6VN6jNupBEGNvQajPHD+1WN9u5sQ8ZVET i0zICjYFidEoY2zr6rDmw1c/VmhAMfXTh9t/opFrWMKbUKgcOiyYVPkhV iqEN/f1SA7WMgkJKabVJISnDToQv3CwEj61/u9DHYKL1ZZSWvrZe8KZXx A==; X-IronPort-AV: E=McAfee;i="6500,9779,10647"; a="79280268" X-IronPort-AV: E=Sophos;i="5.98,256,1673881200"; d="scan'208";a="79280268" Received: from mail-os0jpn01lp2107.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.107]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Mar 2023 19:53:06 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=b3zN+fWfjyuVepqJ70vhmAnRSs/WeKnP9ovzHGIjH+6hxJvMRY+QXESopCOf/s5nNocHsNRMKBsy4KNgqjqsqYMzjJrfZj+Nh9EAs1jd3L6PDTUkG4Fe9G88/97TjV9dp4ft30NWU5qtqcGjqXI/wFq/hSVJfDAbquqQpIH48YJGMqFxgnfS2C8jX+3Ch0tr2pgIWn5Nvx6xm1rxulDcvjleS5u+nZn95pHpyMxAV5pcIq/Jsy7vuRCdO3Ua3cNgvQvyEpeRREat5yPMA9NJh9UNTvLwIjQAccaYH6/DO2FAWiQs9iJq6YHH1/EIsXBQ/rtFj0kjHPJfnQbvPGTqCA== 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=gi9Hz8IU8GgkHuEL8cLfkN27tVRfT7IA8ZkrCRQhF00=; b=Fajuxnn2PXLJy2Kul5LDF21ZPzVNt3l7ZXEj//otr2FhDP80QF7lmPjMjAnZWXmHDHpvRWjnRK4Lucm01EK2vkCGf/LnFI3FvWIN7beYxOz0wJyt8EDU+RiOF0bA6RtEg6LenEU4EhUYOziqqGZBuT1rqvOrzZBi4NWuduJTmatGA4r6dhX9qvJuuQYOnYp6hY6+ROcEwv0arGmlCsVUkLVhFSjWqkcGvyRb6lsuo5WoToN+gq9Sdmr4fo75iqNvMp1DomBgoUonZK3iv3a2FJcZiBGfatRwFeBTr3s/lzfVLDjzWXBMMTnaR7KgBDesKaiU7O6QvIEgln5FQBam0w== 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 Received: from OSZPR01MB6310.jpnprd01.prod.outlook.com (2603:1096:604:f7::9) by TYAPR01MB5868.jpnprd01.prod.outlook.com (2603:1096:404:8052::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6178.24; Mon, 13 Mar 2023 10:53:03 +0000 Received: from OSZPR01MB6310.jpnprd01.prod.outlook.com ([fe80::dd83:55c2:b961:f53d]) by OSZPR01MB6310.jpnprd01.prod.outlook.com ([fe80::dd83:55c2:b961:f53d%4]) with mapi id 15.20.6178.024; Mon, 13 Mar 2023 10:53:03 +0000 From: "shiy.fnst@fujitsu.com" To: =?utf-8?B?w5ZuZGVyIEthbGFjxLE=?= , PostgreSQL Hackers CC: Amit Kapila Subject: RE: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL Thread-Topic: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL Thread-Index: AQHZVFQVM399SsuX9UyA2zNhvf4np674hUTA Date: Mon, 13 Mar 2023 10:53:03 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9NDhkYmUyZjEtNjMyOS00Y2RmLWEzNDItMWJhNDNmNjNm?= =?utf-8?B?ODYyO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFRO+/ou++gA==?= =?utf-8?B?776LO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX1NldERhdGU9MjAyMy0wMy0xM1QxMDozMToyNVo7TVNJUF9MYWJl?= =?utf-8?B?bF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfU2l0ZUlk?= =?utf-8?Q?=3Da19f121d-81e1-4858-a9d8-736e267fd4c7;?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OSZPR01MB6310:EE_|TYAPR01MB5868:EE_ x-ms-office365-filtering-correlation-id: bf78bf62-606f-47f0-595b-08db23b11e9b x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: CwHGtxIvnoupre/YiE5i6YngRAlDYvPZwQhFYYaPV5jX5GQE9d3369z/U8RwysjgmoWJBz1+qB8uaE5ZiybfSI4VPaHaAFCji/MDegsi1NT9SomwhcWe7bgrAFsS+2JKyn8S78RrCerQTp4CinW5zUPd6tG4GuStX8ob7VJdHVKyyzVX3eZP3fa9vmNAJDE70r34QO06550loBSFBiXnHq+/15eAGyR1/iNkOAVaDX5S15GmRQ1uOV6L7bVt4BxbPHqMBPTzP2JcafTi9tZ5VjVOXzpKNhoC2FHI8RPErub04KcDSf2u6iCv4Z9a4BbmopTqdDbk427hwVVG/0KBND1MY2UFTIWPaLTmyub6meF53k8+zmxli2Lu1fXD98ia0+k4ivFH9733CEOKyrH+Dc1DWKxqrImK94+Q+1wxbRY2qvwH8OI/JPPkTNtZ1oEBwvZBqrcxtKQEQw16AEiHRxT8AjaPBpNY/4MVfHSoAELDfJ/WJmgIqjKVV/l0QRBNnWiki1dtaxYXHsxt8eS5DoJ68PCKctbfHf7nSEuf3L4Svcn+JLEKQiLkZl7QnX+oZ16qUyezSQLK7EKuEVfYiIxWS7+A06UKXAKDD6TAZVxAjVauNNzn46YFPPSU8GuoFhkauqngfvdCqXD2NCJPJ39Mmpt2ZyWoENsYW6c75hksKBDed4aeahQOcng25UKwpClNAEISPV7PzkLjSQL4Ys0BMgOj4iliWfwaPX98eBzjWV1UNZ5irT/63fT94ZWANlkK/+HUvxv1cMG9O7znFQ== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSZPR01MB6310.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230025)(4636009)(136003)(366004)(396003)(376002)(39860400002)(346002)(451199018)(1590799015)(82960400001)(38070700005)(2906002)(71200400001)(76116006)(41300700001)(7696005)(66946007)(85182001)(64756008)(66446008)(66556008)(66476007)(33656002)(8676002)(4326008)(55016003)(316002)(478600001)(86362001)(110136005)(122000001)(38100700002)(5660300002)(4744005)(26005)(6506007)(53546011)(186003)(9686003)(1580799012)(52536014)(8936002)(366874004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?TGF4MDgyU0ZPdFR6Zkx3MWcrY1l2SDBVYlpDUk5vendobjFCUUQ0MXRpNWlu?= =?utf-8?B?a2Q1VExjL0RncjJEeDBOTDFOVDhibU4rcENsRXdTMjB0dWkrM1NORjk0d3Nn?= =?utf-8?B?cWl5YlNPRUZER0ZUWWNLSVpaTWd0QnU3VElMeThrRWEvV1BwSlo3a3lFMzI1?= =?utf-8?B?ekhTbUxyMVJDeXJNQzhBWVVYbjFHTlJLbmp6Rm9WM0FzQ0J1MDA1a25tWnF6?= =?utf-8?B?ZVBiY3ZDdEdnY09lTjIrVEhkN2EvU2t3eWptaXZ0M2RqOTJkUEZLQ3RkRVVT?= =?utf-8?B?SFdLTVJaQlhWNlJIMU12bE9BZjlFakN4OHdweWQ0M1BNa2NWWmZYNXVhNUI4?= =?utf-8?B?UkJQSDc0ZEFYK0VWVFQrMkcrOW1UbzVmcGtZejBDZS96MFJKT1NMTjBZbDJh?= =?utf-8?B?eDZGTDVKblpvdUdGNGhmLzdwc3JaTDNWVGJ2a21QQ081eDBUeC8ycXA1bXJI?= =?utf-8?B?ZWgrY2xmUW9RakZTY1lBZ0dGMWl1cEdUSVNaNVl2K3luL2U4L0RJamkzNExz?= =?utf-8?B?YTIxcU5XcmRWeVVDalh2anR6UVFzajBwR2tnNEI4cG81c0FGOUQ0cC82cXdr?= =?utf-8?B?M3VTbUd1V1lmamVqaGtZbHNTSWNOcTNCbGNDRGVtbDJTU2ZmZFZ4M3l1Wmc1?= =?utf-8?B?QnB1SElTdGVyYVdGaUIrb09rWnIxSG43ajgzeHg0WFR2OWxINVFQZ1ZkNnBC?= =?utf-8?B?elZtMlNMNDVLdGxtVHl3bXpURlJ6MnJncTg5eU9sQ2g2YU1POCsyNjE5YThZ?= =?utf-8?B?alBUWEZwWlpsSlNtMnlIWkxnWTB6ZHpPSzg1dUw3a0tBMXQ2R0pGSVgvUUtn?= =?utf-8?B?aUFCd2RyVEVxMTZ1L2tBSDcrS2RUUWpEalNROGtqc0luRjZiVWxFby9UTlQ3?= =?utf-8?B?QjNoSURvamVkMzRFb0RiSWpUemN6UCtGcFpHRCtyWUNWcm1sRlArMTNoR2xJ?= =?utf-8?B?WGF2c3BtSDVqUzY0N0ljUTQ5TXN3VzVCc3p1SXNoR1B2eERHeEZDV21wOU5q?= =?utf-8?B?NWdTZmt4ZE5tQjlLeGg1dUI1YTZnVFJsSWpYaXJuNzJsUkpOU2Fsb29xMW5S?= =?utf-8?B?bUpGVThYTXJQdmJFQVQ2OGIvMXpmc1NWOFBtTENGNWtENmxLcEhKL1Bsck1Y?= =?utf-8?B?bFIwN0wyNTJ6cWEzcHowcmVBbmlRdUhQazlYQ0luL1V1aUxTSWtpbE1zQVJL?= =?utf-8?B?YWJrK0hMUVllUXYyc1Y5RGJxS3kybzdOVHgzLzgrU0FSVEtpZmZjSkJvNEhh?= =?utf-8?B?Q3loKzFMRGhIZVlMY1lmMlA5ZzJOMG1uQ09TM1hwK3VCTzllSGNab1NKa3di?= =?utf-8?B?Y2REdTRSbWFFU1BBSWVHYUZYQnZVekhqVHpITFhtUFNLT21LWTdETDEwMjl0?= =?utf-8?B?OG9Jc1dySWlhZ0FuUmdGN3BENG1wZ09tSTNQblNUU1VYUG40V3lHWHNubDh6?= =?utf-8?B?V1NJcktlSmZ3cGtCMVhSa1pmUGlpMEpQcGs5bWJwc3VEMUpkOVdrVGozN1NX?= =?utf-8?B?N3M2ekw2dGx6Z1NqRTE1MExaQTRQc29jcEpWRHpRM0dUU3ErUFFxSzFKQjFK?= =?utf-8?B?VzArRFBpYUpxeDRweTR1OXQ1aXlvQVJ0bk1hZHl0U3B1anlBQUFOS3d0eW4y?= =?utf-8?B?MXYvM2twMUVudDE5TmdQelU5aUlRWVlIMWFJQkEyV1dnREpmYUlJTnlRSlBP?= =?utf-8?B?SmdKZDBxOTh6TEtTZm43RXlnb3oxeWlaRjRabStINTVLNFRLcC9QTEpESXRy?= =?utf-8?B?QmdCYllqUUZLM3Q0ZnJoZWdpSUNUMnUveW1JbktEa0tpRjlYaFVTZUpaTGRp?= =?utf-8?B?Z3FTRUdOSzA2blZGeFpxcUFDUDBuK1Zpd2NIa3FIVG1jeWttYVhRSlE0a0U3?= =?utf-8?B?Y3JiSjNuUTJ2RnhCZWVCSGJZTDIvVmpkeDlMVlJWdzRvSjhvaFV3LzBUQy93?= =?utf-8?B?b2dnNnlpV1dieEoxejFRUVd2ZlpPMnRwWkp2MHI4Y0ZhRzNqcWRYSkVjVHRP?= =?utf-8?B?Tis4ektad1MrZDBPYVlEVDlJQ295TlJGc2pDbUJLMUdBZitBWWNrODFML0l5?= =?utf-8?B?ZzdtQ0sybmoxbTZXU3N0MzVsa2RBN05oN0srOHZmekhuRnUrTXBUeWsvZ21G?= =?utf-8?Q?WEhIkejmj2zSWNwng+pajXFWT?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 7+Ag5UIgB7AtmP732Eou7BVyN855+KjpnUCtMSJUz27F5HgsRDXLTqdGSW+M7/DQJLX1sZTBDkI992kaP44nzTmYYh6F59LDPtA1RwFZZkPQ6Hn9HlxlZ5nBOZH3kBtTbP0lHr9ZAxBWzvsBNPC59x1mpW/UtiD8gHeuxbtwcJW5a/FPd4Y4gy6UTBbNE9UObbYcBS620RBjYp2oXuZGE+tAmI83DBTzuPZZEBbeLAQw+pFoXLDR9MN1KucSWvrDwl4/v2gvWJIs8WWXjDT1oHXDLOIVqxsBQ7U/aaup5/PDwuA1jFVF12zzsCfL8AantAxXBaWTB1nZaci6OHspfJjhfBq7YUOOPs5V62ilKViWRmwKHRU2VUEx5C8UkkowSDzu9noqDpvrTizfnvysU86e3s9mdUV7XEPFcvJk16KGC8iDUFmpgX5g16Hq2dx6fTSIJJS+Go0sTbFlVrdy46tDmAdmGjtnEm1ckvCNNuNQHFtcAPCdHqEW7Uis2if4zrSpf/3DrWxAHFe4GAxHwSc6hA0ph6xlgfrUsEaorvO7KCJyRY+D4nQLXUph8ll/8d+7NgJ6QF05hCF/jd53w0kYbU/ODF7/l/UVxlKdWhH17jHhKxxdSapFj0+KdOLnnS1pVqAiE5satV7h+8z+nQEqX1T/a4AWwC9ejv/d4SxZ0FmSmGD06NdcRgMAfRLfj6huUVvHhyeBb11axoPmhWcJ4JureDPit7N/lLOEkV6eAhvCDzHVknyxA5DfHOuDBi/15L3fPSzGGqo/rJsBQDDLc3UXYpVQmYvnoXsQRVDQ9l87/LP/kXSwvfS1Qeck X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OSZPR01MB6310.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: bf78bf62-606f-47f0-595b-08db23b11e9b X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Mar 2023 10:53:03.2269 (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: MWMGU7P7ia103j8Mut0Bk56TyQv710Prv4KtTGZhVv+6xdfH00Cv601g5YZpPmlmgfAKd2sdBcFNlyyMl8MNXQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB5868 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU3VuLCBNYXIgMTIsIDIwMjMgNDowMCBBTSDDlm5kZXIgS2FsYWPEsSA8b25kZXJrYWxhY2lA Z21haWwuY29tPiB3cm90ZToNCj4gDQo+IEF0dGFjaGluZyBhIHBhdGNoIHRoYXQgY291bGQgcG9z c2libHkgc29sdmUgdGhlIHByb2JsZW0uIA0KPiANCg0KVGhhbmtzIGZvciB5b3VyIHBhdGNoLiBJ IHRyaWVkIGl0IGFuZCBpdCB3b3JrZWQgd2VsbC4NCkhlcmUgYXJlIHNvbWUgbWlub3IgY29tbWVu dHMuDQoNCjEuDQpAQCAtMjQzLDYgKzI0MywxNyBAQCB0dXBsZXNfZXF1YWwoVHVwbGVUYWJsZVNs b3QgKnNsb3QxLCBUdXBsZVRhYmxlU2xvdCAqc2xvdDIsDQogCQlGb3JtX3BnX2F0dHJpYnV0ZSBh dHQ7DQogCQlUeXBlQ2FjaGVFbnRyeSAqdHlwZW50cnk7DQogDQorDQorCQlGb3JtX3BnX2F0dHJp YnV0ZSBhdHRyID0gVHVwbGVEZXNjQXR0cihzbG90MS0+dHRzX3R1cGxlRGVzY3JpcHRvciwgYXR0 cm51bSk7DQorDQoNCkkgdGhpbmsgd2UgY2FuIHVzZSAiYXR0IiBpbnN0ZWFkIG9mIGEgbmV3IHZh cmlhYmxlLiBUaGV5IGhhdmUgdGhlIHNhbWUgdmFsdWUuDQoNCjIuIA0KKyMgVGhlIGJ1ZyB3YXMg dGhhdCB3aGVuIHdoZW4gdGhlIFJFUExJQ0EgSURFTlRJVFkgRlVMTCBpcyB1c2VkIHdpdGggZHJv cHBlZA0KDQpUaGVyZSBpcyBhbiBleHRyYSAid2hlbiIuDQoNClJlZ2FyZHMsDQpTaGkgWXUNCg==