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 1vKu2J-00CojC-20 for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Nov 2025 07:52:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vKu2H-00Cika-1E for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Nov 2025 07:52:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vKu2H-00CikR-06 for pgsql-hackers@lists.postgresql.org; Mon, 17 Nov 2025 07:52:29 +0000 Received: from mail-qt1-x82a.google.com ([2607:f8b0:4864:20::82a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vKu2F-008ADL-0I for pgsql-hackers@lists.postgresql.org; Mon, 17 Nov 2025 07:52:28 +0000 Received: by mail-qt1-x82a.google.com with SMTP id d75a77b69052e-4ee1939e70bso10354341cf.3 for ; Sun, 16 Nov 2025 23:52:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763365945; x=1763970745; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=W/0VO27W1+ivpirlIgcwVbNRISQzpSRz+3zjb17bO/g=; b=RMDMhlw5BZGxxi1X3Ox07bcSSawLAuCUCUPJMgLIo6+1Dx8QpQOtX2GpvnDY4VdmnC fneFxrDh3lUu5JNMyeNfghArf4RRlCryctl0m2bCVff0EGgiYTelycDfk+WilEE+SVc7 D8PdPAcKwPsnqYYTbVj09iybw2NCMIe9b6OosQhEDWHojbmXT8sH4fM2yKimWn0GTWZ9 Zk8fOoThqa7N526GO302hacvH4K9KdxJE+GfCGI37NNsjydtDCgp7vO+KtlWkAJyHkU9 QVfMPA3cDuYkXqrFCAxKca9PrUzBO2MlqKeTC4vFL5Rri0FJt3epbkO1hkbjnEit81sw 7woA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763365945; x=1763970745; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=W/0VO27W1+ivpirlIgcwVbNRISQzpSRz+3zjb17bO/g=; b=wimc/HNTkj4z57JY5+i/1iVgxm67gyxTakMeCRVByQBfwFFasx9dWRcRTm+9V8hze4 3XDSnO+qg+N9XI3mYJPNYwuhxaS4YmRo6LPeo3Xgb0KRm6NFljvrI8L34Kx+tdWjkdUv wCu12YvpZtG5ZfifUUXjGuRoHrOBKahj6TyspWC7tm78v5UW1lFu4DpONg+aWRoFEpAq Z88Ypzt8MpQLvCEXVzQRXKTwbQoqx4GTquITFsKejLoA5lDjTFp/7S9F3EVy6jz9kjSa qphFYMqJDVMFqoKxkbwgsr+fyNjCbijJTZWmYk1goH6Yb3dzTO0clzfCVUH7lM4hhqEv g+Tg== X-Forwarded-Encrypted: i=1; AJvYcCXx1c5BK7KwUmzZxAy+Ti1udFRgESX9nkGxy1XM/D0qBIVNnDi7PAlh8tltANdP99NNKhKAY9FUtDQ0Qqwh@lists.postgresql.org X-Gm-Message-State: AOJu0YxFAF6UYND4T1aFC3Rd41IRWUalR/lO64UxDK1CMBfGIlwLUmBL MQnY4gNe2hL29slstJSxly1iNG8aW/Tdcn4ExxDfmw/Ld/2d2BzDXkcni/w+6p+NKUEKT474gv0 11RblGQ1TEYHXHikAO57dSVFf4jd0gmE= X-Gm-Gg: ASbGnct1IoCwlqsFWWAUQuUxGdY2ajnohpRuCCrChTRNi+jHXAnO67f/cANUOVPUIN2 xxzimDMpMBPJkdUwGLMOlJkos3JBiYnmWJ6a1XZjBxmIfPap2EvGIfYZIWfZ/zlSoL1PtTaR2u9 pzDfyHDoMksKiCKi7iLoeBfHHbGYpI50r9M47Wt11nWhXVwCw/BW2KNHIFSdmR2+4dc3hbYa6lm 4gwcmQzrbScd1F+BAH6WDmQ0oZUE32pWl5F/0wGJwaajQf2e55tVeNoxMuGwQV6cyDQwC5GiYg/ AglvLUKObcpu1K+YspY= X-Google-Smtp-Source: AGHT+IHO5mpDokeeHvmxUOmwuvsEL13//pKcIIJ2qQ8yH7l3Zdl32dXiWD53dCZI4LtF27sghswCS6lgLovhSjr0xb8= X-Received: by 2002:ac8:58d1:0:b0:4ee:1ee2:f94d with SMTP id d75a77b69052e-4ee1ee2fefcmr39284391cf.6.1763365945210; Sun, 16 Nov 2025 23:52:25 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Peter Smith Date: Mon, 17 Nov 2025 18:51:57 +1100 X-Gm-Features: AWmQ_bm3-nByf30mL7P1W8F97jbMp6Yom-Bs3hWDMhDEXI7okF9oxA99jDj1LeA Message-ID: Subject: Re: Skipping schema changes in publication To: Shlok Kyal Cc: vignesh C , Amit Kapila , "Zhijie Hou (Fujitsu)" , YeXiu <1518981153@qq.com>, Ian Lawrence Barwick , Bharath Rupireddy , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Shlok, A comment about patch v27-0003 ====== doc/src/sgml/logical-replication.sgml All references to tables "t1" and "t2" should use the tag in the SGML. The current patch has broken this in multiple places: e.g. - Create a table t1 to be used in the following example. + Create tables t1 and t2 to be used in + the following example. ~~ e.g. - table t1 to reduce the number of columns that will be - replicated. Notice that the order of column names in the column list does - not matter. + table t1, and another column list is defined for table + t2 using the EXCEPT clause to reduce + the number of columns that will be replicated. Note that the order of column + names in the column lists does not matter. ~~ e.g. - On the subscriber node, create a table t1 which now - only needs a subset of the columns that were on the publisher table - t1, and also create the subscription + On the subscriber node, create tables t1 and + t2 which now only needs a subset of the columns that + were on the publisher tables t1 and + t2, and also create the subscription ~~ e.g. - On the publisher node, insert some rows to table t1. + On the publisher node, insert some rows to tables t1 + and t2 ====== Kind Regards, Peter Smith. Fujitsu Australia