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 1vSZsB-001Dhp-0d for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Dec 2025 11:57:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vSZs9-00Gm4J-1O for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Dec 2025 11:57:45 +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 1vSZs9-00Gm4A-0L for pgsql-hackers@lists.postgresql.org; Mon, 08 Dec 2025 11:57:45 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vSZs6-003qCf-0U for pgsql-hackers@lists.postgresql.org; Mon, 08 Dec 2025 11:57:44 +0000 Received: by mail-pl1-x636.google.com with SMTP id d9443c01a7336-29808a9a96aso46248465ad.1 for ; Mon, 08 Dec 2025 03:57:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765195059; x=1765799859; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=KcVXCLBtyIF8wr/0YtW9/9DiwulgSRxVh1RmNtO94mE=; b=SsFZUnc1E5nBKYgvoQntAREbIF4pIlN1l73O+Vz83kYxD7V+s/jdTlch4uOQtF+up7 v5d8x73ETkaMFdFImukXhex7Elqhr3Zcbi1rXjLfrDyxB7Sf2Gm58jOcQF8wp3Mj4qk/ pr809g01csbUvJTLVdxI0bk4JvIiuIe8CZnS69XY6Qas9ofzjfAjNRsJuqi06inXDmGB UNuaxQeimqEAsXEgz3NgmFYEwpQ1d5xIL6m1/1eS6pmgo6W3xtm0Eotzw+eNtXI+WGp8 2L+0tsIjoDeMp9sL0964HM6NXrbap3phKWOOCSEPKhDpIDZUAyDdryAhAAYUFI4tyR1y ajvA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765195059; x=1765799859; h=content-transfer-encoding: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=KcVXCLBtyIF8wr/0YtW9/9DiwulgSRxVh1RmNtO94mE=; b=iobe+w7N4vB23HvfUJG/PTXY3YblUu0daFcM87IIbUchGjV5Lh1bcquSGLICwOkKqa ljjzEeTWnab1WlOR1CKeshz9wc6t/Wg1QBnCoVh+0cJQgkCuNlpdoUFTwQGNHoah4qcd RuUGFjQVZ14iy65R7YABiTR2DiuERV2Ng7Ln7U1+yKXd5vfaz2aoJ9g1yN/5/wZ49S/i n7jtbWI/l90H5e3BRaEsMsnwlT1AYn2AZQX54koanvZufbt8qCc49mGyGpCtiaiDpthk Tok4BkCOvqH9lP0xSUWWq1fnDa/mmXcjjji1Zxa0RdM6SrzW7VCj+DwS7QzA3YlNQ/// Ub7A== X-Forwarded-Encrypted: i=1; AJvYcCU5eVzlo8vFvihMIeo97HhtVvjWKPLK/Mab3zn3ccx0IRAuLLMdE0wAVfbFaYs0KK2PyBnGyu4q44AKct3o@lists.postgresql.org X-Gm-Message-State: AOJu0Yzu8d4c0BYkyJhEqlLFvSKOtkSeHB/9fFGGzwwcbVEVf0eUp+A3 NuysNPnpfVggOyOOMbpxF/76eiyOxiJHzUr06jeYc+82hyd9Jg+ye3tQ1M2qIzF07gpeQOWleIm +BE6F56jcQsWBumpRIRG1UwyacvDq9zY= X-Gm-Gg: ASbGncu2SePFnKMg1yvwPmnA02AShg7ok4D7dfDpXR3tAhMwk0IwlshCdnQcNzunhpK AMK5JnaQbU8dNhPz1A7mO8k4Y8Hv7RPMjwwt16lIbIEdN0ZwNOw0LTr5FyYArBqmKR466AB4QRC WeuNPeIW6Mr9jhbqE0zUDR7fASyjEA7HEYqGmoOXALll+xYfika1BbBrBmi8H+EBDuhF14iQvaO EpnKGipVcYbSC0avZhxLvBL61MT1mpc50bmR3ti+nwQFnXA1nbn1Zfc/7UyIk2FJ1CmBo0DUved iUH8QGFIb6Vdlu+xBrUPAW72hRSpzkjVnHEr4dpP X-Google-Smtp-Source: AGHT+IF1U37b550tlfTf+EVG9v3BHYXVzlKxsJWMMU9wBpj/PO3R1vpLahAvujmQdv+1pOHLRz13s+3L+FwkpPmpWbU= X-Received: by 2002:a17:903:240f:b0:297:d45b:6d97 with SMTP id d9443c01a7336-29df59a8867mr67837975ad.14.1765195059290; Mon, 08 Dec 2025 03:57:39 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Mon, 8 Dec 2025 17:27:27 +0530 X-Gm-Features: AQt7F2qa8LklpGla2vws7yfQrMiXJYwkEXU1BfiKrBhjPxzvg-hZWiEsm00DY_M Message-ID: Subject: Re: Skipping schema changes in publication To: Shlok Kyal Cc: Peter Smith , vignesh C , Amit Kapila , "Zhijie Hou (Fujitsu)" , YeXiu <1518981153@qq.com>, Ian Lawrence Barwick , Bharath Rupireddy , PostgreSQL Hackers , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Dec 4, 2025 at 5:21=E2=80=AFPM Shlok Kyal wrote: > > I have addressed these in the v29 patch. > Will address comments for 0003 and 0004 patch by Peter and comments by > Shveta in next version. > Thanks for the patch. I believe patch 003 (EXCEPT table) and 004 (EXCEPT column_list) should be the primary focus. The other patches, RESET and ADD ALL tables are additional features and may or may not be necessary depending on further input. I suggest making 003 and 004 as 001 and 002 respectively, and prioritizing these first. The RESET and ADD ALL tables patches can become 003 and 004, and we can review them after the first 2 patches are fully evaluated. The documentation formatting changes for ALTER PUBLICATION are not required in this patch and, if needed, can be handled separately. thanks Shveta