Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w39nL-000xWK-2Y for pgsql-docs@arkaria.postgresql.org; Thu, 19 Mar 2026 09:36:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w39nK-00HNiZ-1u for pgsql-docs@arkaria.postgresql.org; Thu, 19 Mar 2026 09:35:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w2sIi-00BkxQ-08 for pgsql-docs@lists.postgresql.org; Wed, 18 Mar 2026 14:55:13 +0000 Received: from mx07-00501504.pphosted.com ([66.159.235.102]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w2sIc-00000000NKs-2UXm for pgsql-docs@lists.postgresql.org; Wed, 18 Mar 2026 14:55:10 +0000 Received: from pps.filterd (m0427085.ppops.net [127.0.0.1]) by mx07-00501504.pphosted.com (8.18.1.11/8.18.1.11) with ESMTP id 62IEEX3f1731421 for ; Wed, 18 Mar 2026 14:55:06 GMT Received: from mrwpr03cu001.outbound.protection.outlook.com (mail-francesouthazon11011018.outbound.protection.outlook.com [40.107.130.18]) by mx07-00501504.pphosted.com (PPS) with ESMTPS id 4cyf4vdxfv-1 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT); Wed, 18 Mar 2026 14:55:05 +0000 (GMT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=xJuw8/ZyQ/YTyFebCAsMYAMvVo0602Q6YmSzWMExF8H5ECFwiFgQKB2VnD0R8qSriU0gTjCkQR0rlnyUX3HASTL02jUKjlcZ+5laII6vCxxhMe7uK/8qRIGNukoqE36zeYMUgXbySjG333/RgZP4Xyl4xnXsQiH+x9MD8GY+BwJQGwT0zc4Hs8y4ZXNsjMB/palsWvEwYRS4KDVqaMA1VrzYYVW7AHJui4pA8roLq5yhlVJGSIEtWKTfgHpFCYOsGYj8XUzSrHZ6N0QwPWziJn6O79++g5/0Y2ByleWQbYmdDCGr6c7GcxZimfH1fLyYRjOgdl40fyxX0Fk4k9Csvg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=gvg/89PZN3sMDXisXeOmK0g/pBCNlR/X1iASACCXPfM=; b=Ldf/VWlEuycwzKgfo4HOy6ibYjk93awkx9DlnN6QJCQ0O3x20gcNk0RHJ4ao1S8KP/VlbV27d+BLpG63m355FezV0y7IZxjTRKQRvdnJ5BAgI+7mYTIpCsVUZiOUtDfOS5oBmXovDc9/UVBw6o+tBKZmoqcyFj7ZdWuQ7wEWCZkea6jfgxCa04LgDW+61eZjHgQ6jNFB0uqS8vFjsvFBVMvLEF6IST75bdI82s3FCa9AbqaqMX30JS8s0Xwpk+vxldMQYqOgCARCGNv9WtHu/F2WCtCThcZLpFbJj7K+Sy1YWwjBrIW5Qf8c8T+SdffxaYLT/v4LFy7nZy3X8VajDg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fisglobal.com; dmarc=pass action=none header.from=fisglobal.com; dkim=pass header.d=fisglobal.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fisglobal.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=gvg/89PZN3sMDXisXeOmK0g/pBCNlR/X1iASACCXPfM=; b=x1p1SMaD72EE30l+BaKxN9cTabOnrq8YNlpCa17QqTterF5W+XdjgoMGfktMHAmRyYfxjXi0kl2hvEt4BgXiHt99c+GQ+cNgYfXHa+nmyJ5RmWK4wlB4sked8MD4Tb9sTwvjsUZE6xejzjnZyZPI7vu1RzX9Xb3ESnPP8y2bxe0G1kvTT0UljZ6/eKZWE/TwrqInKM5j66op9iRrB3bsEXonlio2iP9HA7d8d6e4akrzHBQlce2iCHP2tyFjFkGbl4aEIr5F7sv/3jXVFTOlZon/Bzq8B1ZPAnL55Wl5X/vRRq+QQ27o3vzRJ8up2V4kUNQu6qhnTSPu3uy4fRAj7w== Received: from VI0PR08MB10512.eurprd08.prod.outlook.com (2603:10a6:800:203::18) by PAXPR08MB6432.eurprd08.prod.outlook.com (2603:10a6:102:154::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9700.24; Wed, 18 Mar 2026 14:55:02 +0000 Received: from VI0PR08MB10512.eurprd08.prod.outlook.com ([fe80::139e:f538:bde6:97f5]) by VI0PR08MB10512.eurprd08.prod.outlook.com ([fe80::139e:f538:bde6:97f5%5]) with mapi id 15.20.9723.018; Wed, 18 Mar 2026 14:55:02 +0000 From: "Blaziak, Sebastian" To: "David G. Johnston" , "pgsql-docs@lists.postgresql.org" Subject: RE: Conflict in documentation Thread-Topic: Conflict in documentation Thread-Index: AQHctskkda1ir5ORnki6wvH+M7Kt57W0VZaAgAAKRYA= Date: Wed, 18 Mar 2026 14:55:02 +0000 Message-ID: References: <177383263022.811.383346008182718806@wrigleys.postgresql.org> In-Reply-To: Accept-Language: en-BE, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_ActionId=eca67b3e-ff0b-48b3-a341-7829f19bab56;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_ContentBits=0;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Enabled=true;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Method=Standard;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Name=Internal Use;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_SetDate=2026-03-18T14:51:33Z;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_SiteId=e3ff91d8-34c8-4b15-a0b4-18910a6ac575;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Tag=10, 3, 0, 1; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: VI0PR08MB10512:EE_|PAXPR08MB6432:EE_ x-ms-office365-filtering-correlation-id: a6f1c1dc-d118-4f09-5bc5-08de84fe55b1 disclaimersource: eop x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|13003099007|8096899003|18002099003|22082099003|56012099003|7053199007|38070700021; x-microsoft-antispam-message-info: VItthCcIuyRf+bGpBUkaTBlXnp1UfZabDWubZqf0M87G2i6hWhLdfVqeFT27VwWJgErSGTe6QOfysRLiuF+Ru+SL7nRc/LfqHgT5YqHI/D4FRBiXu7Wp+whlb2/bxUFH6BOhHMNOd2eKC020/AtF+ikeclB7TQ5ctbM836X8/q/6KOX/NiPR3UANMos/N48uvJ2Qyk9TdEe2AErT+ECdkThXveGDolv9Hspy1PCuQYcmOImai1axqHS0GEcHNqGuqUGfznvt7NQ0HVWG4t90UyjBewN55D8dQJJLPIz3DylsFh3HA+URYARsarKcT6rZDEn3oNeh8WCPDpoD0/YBjjkiFsVNjfBSBkI6EdgY3Y2bDJJyzNiMjpDKzki9wG7Bmbtmekxe2myftfyqZU82IVAal2bN2Riu95Xq9u1P9K1e80CA67wapQyMmLuokj89juT2xEDw7omiWEXM4GTU01tex3pLfqU+t0U3Ixh0yGTS17TRfjiJw8VOcvCWBRyq+9xKMdEDQM4Gv98ZpgcMu6zFlleBcHYDtWzB9reCHMzeDZNJbN4/3b8jLS/mJ3uKo2mzHvrlMW2fWik95Dbff24PEKc5yTLEMKZBmnqWIRONl9QagT+Nx94Mxcz+5W4sZ774qg7UJ+LQJg7kVov+gD8DkQuJ7XcgzcOFUd3QbJuVsyjkwvVYhWN/6pDAx/qc7FBMISjAJroHbi0xuqnGaEg1YZxqQruS425uqSThMsRURxSBILMcz11pcwr8W2G6tjUAIWe+4fbX/BbS4/hJD+bbSHLJPqB1KctiaDvU4IA= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:VI0PR08MB10512.eurprd08.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(13003099007)(8096899003)(18002099003)(22082099003)(56012099003)(7053199007)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?rBUOUyqHhySvndEwdWOij9j4hjYEctktqGRAv4yuJG1sicSxFH7BIrVfb+UN?= =?us-ascii?Q?etEBetIm8F+3F3lQtm3iarpZfzgf59boPSvofbpsAUKIp+kdQNLDa5WyOI8i?= =?us-ascii?Q?zBT9TczPZTW/mdtdb+aQJlSSxMavhNET5UgWEzTkY1m7iEETFpMi6oC6/zDE?= =?us-ascii?Q?9LIjn73iW03gLBtdmX0hYagdR2s5iOwpcWqMF8oAuFfR53avsa09QM2oDnyg?= =?us-ascii?Q?pvnPJrStp1anf0foitvYa7K14RK+Jlmentsc2cFMX83aac2MnEeA6c0bhaPA?= =?us-ascii?Q?tPgJrRH0zOiz5Qt+J7QvpOZ7DnjbIHveBDr1EvTDEuuTXPqq99p4vJTezKJq?= =?us-ascii?Q?bT+anslWf+8QO53R6MAlWlaHZ4cTkR2AwP8aycjVfimyxNTRfucvb8R51F81?= =?us-ascii?Q?7uV9zNbfzEU/1rR/SGPq/+0pw/DygkxgiI4YsIy1r50u0Dqiu4esCGbxLNs9?= =?us-ascii?Q?OTn0gNi9PTQLqpBksnZEYkkKmMUgngmY51CCg3TKUV48bQaKAP2tF3oSRlG2?= =?us-ascii?Q?f4Q54yKXrvyGz6HxsFHq65uYO5rNKCDAUv0YfhQIe68tW2QaEMmTYcOjN2rs?= =?us-ascii?Q?R0B3KnlkkQZX7M9MjPqVNCk+zvHcvwlwPlhCC8Bp0sbNLtU2xh+pfNN4yNcA?= =?us-ascii?Q?p4PF1TrQbkkymk/0Uj1I3Zh1Z+BXCBU/kEMd3IyQnorVQroazEosYUwsE7+g?= =?us-ascii?Q?PyuWsBwm/EpER7Y2nKg4SwjKjjoKMaNJrWyM0Rp9LXlDc6DEDo4EVxyNDRHD?= =?us-ascii?Q?heE11Kr/VInMx9ONm5OjaFO0jA7KGInSAjLK2vzYy/o/6OcPJFNv7T/JiZUK?= =?us-ascii?Q?I/7GTVLe+f8C3wMvCmmO4EUMBKaxc7eRODz29Qa9hSxoHS3DGMWfIzECFfNF?= =?us-ascii?Q?d03IYmB9oL+iWC2ZiG7EgZ8OOGr9TdULdHwIb427I7vHu0JKBocBK8unVji5?= =?us-ascii?Q?v7FTewG0NwiCw7qoNAjgIaEeF0UcVsVH54ZUY6xGQdWSe3cj0/ky9Q7h1RVt?= =?us-ascii?Q?V1+dJEcOOlas3gaO+iMr3Dav3HhpYj78bZIlRHuuuoH5ewinbtQT/CHHeWXZ?= =?us-ascii?Q?TY3BS+zlE8SEhpYjpIaUpUSsHYXa55X5grmMkdGNJ26RG05anYt7Ht5GLe56?= =?us-ascii?Q?EmidwlxPu6M4lMrAvONXm9oPRXTqz042S2f4pyWCqmGwOA1gY33vvNdm06q5?= =?us-ascii?Q?L1Uk3sPXpHYxzLb0/wFtR0zk649Ynzso4lZxueXnSiWvtw+k1ZYf16m7U4Q7?= =?us-ascii?Q?rpmdYPJXPx8R+AqDRMAGnO5mikeTOBOnIpwe/v2UZ5g/ebekYKBZZYV2Mirj?= =?us-ascii?Q?cS+1/aNdsGm0OaIk13a8Tl4J9wzN8zG5OYIFXVZ4v11eObBEqHv+t/kejPDm?= =?us-ascii?Q?q1J7z7ygRjJA6WclvhOedFb84F/DXHNsz/KLlyMBZ4TuERHocnyr8Lv4tsR4?= =?us-ascii?Q?nYa0TxjMssPq6EiuV1IGsNn4JTXGtXXIfTIIQ0ukphH9pIVsKezYsmMoOc4y?= =?us-ascii?Q?Z+O/evfLBTLKLGaxMRHKxJadHsJWieReu8Mo98+RfyOTrKttgZ0N6gXe9pKu?= =?us-ascii?Q?K2UfkEfXRyZ0Rr+dUCPP7Ul/JIesmLVPeUvUo20uaOmon4veCD674d3jQJZm?= =?us-ascii?Q?nDJglltDExUnm5JpqWJU9oylX2OZoa4Fb6d8RCYVq6xFSMzcDYrqN+rIlgzC?= =?us-ascii?Q?44bw7rmq0Ee2Xf2x5t/8lRL+LP0G+/tiEMDB5zLoRPErHdswEUUw11XiyRZt?= =?us-ascii?Q?QP/YxXRpdlfOYDHdFRZL5Rlq8q074cs=3D?= Content-Type: multipart/alternative; boundary="_000_VI0PR08MB10512BF815525F86DB76287B5EE4EAVI0PR08MB10512eu_" MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: Vr9v//nqHGn/uYFE4iMc88teSNCdv6xX6UROqb6ATDTyC8abGnOpWxqjYk08/iw5cQVAkgVCHpnisBe7yYnkY13YTMjF4M4oj3nOHu4MqKFi8Vh40AUXJKJMoDi+OsQjYVW8fGfx0JCfSM/OGmgDRrV8xsPmcZlf/BMnaU98yM2+08Zg9EdWa9aU1N62OjdYK5dVZyX/R9iIV8ihDMGQ7HpMM/i79uTQpU/JyBgmqk2dOe3V+w9t9lZzogqGBIT0fw8igcGjncRAe8sCydSQEBbNIrsFrbQXCSvBcYFhY9jSU/C1Lr/Kois9rcna2OY1uODEOvlAJs2yU9JUc3yyHg== X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 5u8Ac/1W96/82Er3p32g1AY2p1BAkgKvGdlALMShYA8w1uYX9wkkETR5CrcpntJynG5pFOJ34tI8bqMQY9Kzu1Qg36w1E9WXyZRFBpOpnjtAG5qZpXSGmdO7wpxR8u1DlvtlH9nFCm8r7M28wHHu9dWzoCe21bQmA52m1QilesOOw1KJMRc1KGIY8mSL066iVbL02GCmq0f1IC/pCs8EV+0FCYmoKzIfNz6pzfuCYSwD7nlUiecA0B6pChr+fGwt6Sy5IDcSh4tHp/rbrr9jxm2YN4iIJVJaM/7lgBWffvWugnf3kxgMKfy+gE1ICn5G0SZA2L/8t1n7EQswneCbu79zJLX5Ev2c8rjXmvFR6Xj4zb3BpznyMYQCTqfUqAqcZswCb+h3AqD9zsa82fZlbo6KpDWZGSaXob99EuIYWXCmLOULepyURa2TIHTG1JdfH/J3WWy2NGD+Bwp45Yjqmx2tOsMA///YU4OYWnXjjsUE0N/Mz6mkJzxJEVIvvQbb1XDkzijBeyMaH/FTEuJW16NsJiG77ilkJNUY+O6CckfRxGnGWACHIEYw+f7hvx0kkDHSn/XzkTbXQWfQiDM22QHSa6mwe+7FygEXGf4y+NsNjw918XcpYrZGE4xQVcu0n915xi1T3E/u1r7N46zPAg== X-OriginatorOrg: fisglobal.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: VI0PR08MB10512.eurprd08.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: a6f1c1dc-d118-4f09-5bc5-08de84fe55b1 X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Mar 2026 14:55:02.7231 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e3ff91d8-34c8-4b15-a0b4-18910a6ac575 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: CTZ02iHYGnZyOA306txQNh/GJQIm+L0QCpGNozEdLqFe1+RWvpnPVtmu5cH3Nhk19FSUsSQofrxac1BEujTM3FVuzJL3xb0QbW+JR84H1KI= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PAXPR08MB6432 X-Proofpoint-Reinject: loops=2 maxloops=12 X-Proofpoint-GUID: fzkcveD6okmtjYZmCHwdxN4OKeISxB8z X-Proofpoint-Spam-Details-Enc: AW1haW4tMjYwMzE4MDEyNyBTYWx0ZWRfX7RxybaiV9OuM pMizidW5c7HtX60Au/DOsf9wVIq/pPtmT4SeRB8tIxH/2PikhxdN+6o1o/XdKHEUP7br4cfiFiw qVcrJKyhulNBJb9nXx2onL2h/vhuMh2UMNRsnwT5QMaGeouehnvHW0cg5nVcfsHv0g3keFrc97J oqc2DZb0Vi/ZuKG9rqk01z4omQBS3kgZaWCwejptZbp0OTVodg17sBQgVnUDNVwf5At4OFgIjRE WmvCgprFtbDHIHYrzMpXHU07/L7d+860DWC864xPblsqIEsiZ6nFvJaRToPDAB5XhIU+D9+hpkd YfO6vGf/j0WUQUlm8gtGOIUI7n3D61jLCpDrpqwes+OkXN3n8E7EJDDcCFpiQXZtHcnv+edbWF8 cyZZM+qYAtP30sR5zwPWwkquU5R/aFykhGOLoYTq/5y4IrdtUfNNXY9ZKxvu3v5QDRZixF2vitY qAG+KwqHPne5AU/5Yxg== X-Proofpoint-ORIG-GUID: BM3cV0GdGA4t3DcBOogFwblmza0tjwNN X-Authority-Analysis: v=2.4 cv=EsnfbCcA c=1 sm=1 tr=0 ts=69babcc9 cx=c_pps a=CZW6tCy842DzIvplWb+nyA==:117 a=z/mQ4Ysz8XfWz/Q5cLBRGdckG28=:19 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=xqWC_Br6kY4A:10 a=Yq5XynenixoA:10 a=igHI_3hapJUA:10 a=VkNPw1HP01LnGYTKEx00:22 a=paD8wXUPU7R37nW_kjPb:22 a=zca8grFVCJoyLxjD6-G4:22 a=epTmVMiNAAAA:8 a=pGLkceISAAAA:8 a=40I6_EIbAAAA:8 a=El1oJGavTwfK_1nLL5wA:9 a=lqcHg5cX4UMA:10 a=CjuIK1q_8ugA:10 a=yMhMjlubAAAA:8 a=SSmOFEACAAAA:8 a=Lda1h-njO6BTz_jeWckA:9 a=1SgXC_GMXsCK2CDn:21 a=gKO2Hq4RSVkA:10 a=UiCQ7L4-1S4A:10 a=hTZeC7Yk6K0A:10 a=frz4AuCg-hUA:10 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1143,Hydra:6.1.51,FMLib:17.12.100.49 definitions=2026-03-18_01,2026-03-17_02,2025-10-01_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_VI0PR08MB10512BF815525F86DB76287B5EE4EAVI0PR08MB10512eu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi David The first line states that the initial data copy will _only_ copy filtered = / relevant data. While warning, but also elsewhere in the documentation it is stated that in= itial table _does not_ respect any publish limitations. Hence the conflict. Thx Seb From: David G. Johnston Sent: Wednesday, 18 March 2026 15:15 To: Blaziak, Sebastian ; pgsql-docs@lists.= postgresql.org Subject: Re: Conflict in documentation On Wednesday, March 18, 2026, PG Doc comments form > wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/18/logical-replication-row-filter.htm= l Description: On page https://www.postgresql.org/docs/current/logical-replication-row-filter.html= #LOGICAL-REPLICATION-ROW-FILTER-INITIAL-DATA-SYNC If the subscription requires copying pre-existing table data and a publication contains WHERE clauses, only data that satisfies the row filter expressions is copied to the subscriber. and Warning Because initial data synchronization does not take into account the publish parameter when copying existing table data, some rows may be copied that would not be replicated using DML. Refer to Section 29.9.1, and see Section 29.2.2 for examples. conflict. I don't see a conflict. But I also don't really see the point of the warning - at least not with it= s present wording. There is the initial state and the change log (DML) and= comparing the two in this manner doesn't make sense. It's seems a bit heavy to say: warning - publish does not apply to the init= ial table sync. It seems like it could easily just be a note; or removed a= ltogether as we try to avoid documenting what things don't do. That all said I'm not planning on trying to push for a change here. David J. The information contained in this message is proprietary and/or confidentia= l. If you are not the intended recipient, please: (i) delete the message an= d all copies; (ii) do not disclose, distribute or use the message in any ma= nner; and (iii) notify the sender immediately. In addition, please be aware= that any message addressed to our domain is subject to archiving and revie= w by persons other than the intended recipient. Thank you. --_000_VI0PR08MB10512BF815525F86DB76287B5EE4EAVI0PR08MB10512eu_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi David<= o:p>

&nbs= p;

The first= line states that the initial data copy will _only_ copy filtered / = relevant data.

&nbs= p;

While war= ning, but also elsewhere in the documentation it is stated that initial tab= le _does not_ respect any publish limitations.

&nbs= p;

Hence the= conflict.

&nbs= p;

Thx<= /o:p>

Seb<= /o:p>

 

From: = David G. Johnston <david.g.johnston@gmail.com>
Sent: Wednesday, 18 March 2026 15:15
To: Blaziak, Sebastian <sebastian.blaziak@fisglobal.com>; pgsq= l-docs@lists.postgresql.org
Subject: Re: Conflict in documentation

 

On Wednesday, March 18, 2026, PG Doc comments form &= lt;noreply@postgresql.org>= wrote:

The following documen= tation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/logical-replication-row-filter.html<= br> Description:

On page
https://www.postgresql.org/docs/current/logical-replication-row-filter= .html#LOGICAL-REPLICATION-ROW-FILTER-INITIAL-DATA-SYNC

If the subscription requires copying pre-existing table data and a
publication contains WHERE clauses, only data that satisfies the row filter=
expressions is copied to the subscriber.

and

Warning
Because initial data synchronization does not take into account the publish=
parameter when copying existing table data, some rows may be copied that would not be replicated using DML. Refer to Section 29.9.1, and see Section=
29.2.2 for examples.

conflict.

 

I don’t see a conflict.

 

But I also don’t really see the point of the w= arning - at least not with its present wording.  There is the initial = state and the change log (DML) and comparing the two in this manner doesn&#= 8217;t make sense.

 

It’s seems a bit heavy to say: warning - publi= sh does not apply to the initial table sync.  It seems like it could e= asily just be a note; or removed altogether as we try to avoid documenting = what things don’t do.

 

That all said I’m not planning on trying to pu= sh for a change here.

 

David J.

 

The information contained in this message is proprietary and/or confidentia= l. If you are not the intended recipient, please: (i) delete the message an= d all copies; (ii) do not disclose, distribute or use the message in any ma= nner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to ou= r domain is subject to archiving and review by persons other than the inten= ded recipient. Thank you. --_000_VI0PR08MB10512BF815525F86DB76287B5EE4EAVI0PR08MB10512eu_--