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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wXPwK-003FkJ-2Q
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 10 Jun 2026 20:54:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wXPwJ-00D4QO-23
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 10 Jun 2026 20:54:19 +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 <zsolt.parragi@percona.com>)
	id 1wXPwJ-00D4QF-18
	for pgsql-hackers@lists.postgresql.org;
	Wed, 10 Jun 2026 20:54:19 +0000
Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <zsolt.parragi@percona.com>)
	id 1wXPwH-000000024Nq-2oLk
	for pgsql-hackers@lists.postgresql.org;
	Wed, 10 Jun 2026 20:54:18 +0000
Received: by mail-yw1-x1135.google.com with SMTP id
 00721157ae682-7dd3f176f84so83420287b3.0
        for <pgsql-hackers@lists.postgresql.org>;
 Wed, 10 Jun 2026 13:54:17 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1781124857; cv=none;
        d=google.com; s=arc-20240605;
        b=E3E4jBbzW9GpptHoVxjBBbMHLXvB0oX3xOG4IU0G0Q3OjEULLaK9EmWCvAaDg10Mk5
         8iLPPpn2yMoBS1HvLsgGpQceRBu0JXjGe8VKH5ZrSOfvZDF8ObOOWuQQwmycj/ADtqF1
         vfan1eH1+j5Mf4RebRnWyL5UwjesyRaOld0MjzQYfIpEC5EALN+H6k9jRY4kV9AdYj2l
         Y9XLRhtkYWAgx6V7YZjbC0h7ZmbOAryiW6zST18V+dWtO2iInphVnc/ahYG0geQCtb40
         1WiI+ESrMcxCMIEKnYlqBGlEhMU57HLP8Azt52+CP5rJMW3ho97Yjp+8qlxxJxGqMKFh
         QNrA==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20240605;
        h=to:subject:message-id:date:mime-version:references:in-reply-to:from
         :dkim-signature;
        bh=cpHwfZUDsWSzZr9EiUqwUxTo6PjPMUtgi76bDXJ/v7g=;
        fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=;
        b=P0Mm2h7OTw9wzgXRZ3khDqL1S7yn2304aWtcc9a1duZHbwlWN9vSqwcfQ7Dp2G78Q4
         xPQ8oayC31zuwQYuqi6a0qwV0HwzZ/p3R633dcEGDOhDDqabpeMgKYK5FBACZrtang9d
         pI3/lb0F4vMITZT7JoZtWM6urfQ4iVmun+YNu37ChT8TX7hoNRkM6A2QP70/iUqBNBgi
         6SgLuBbv4MM28Im9a8nS26KTnb33rYsxnu7dPy+yf3IZAiESCq6+kpQYr87AU0nHrw3k
         hHXQp8W+OGd1H/NnGiS+i+E+2mcoZn96yylrJNn6d6pFuqqajzwURqs+SANUNqJCHYE7
         T4VA==;
        darn=lists.postgresql.org
ARC-Authentication-Results: i=1; mx.google.com; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=percona.com; s=google; t=1781124857; x=1781729657;
 darn=lists.postgresql.org;
        h=to:subject:message-id:date:mime-version:references:in-reply-to:from
         :from:to:cc:subject:date:message-id:reply-to;
        bh=cpHwfZUDsWSzZr9EiUqwUxTo6PjPMUtgi76bDXJ/v7g=;
        b=NnYnYUMbCtviy2L5G2wV88OFnVVpYlFS6b8xe7e/WUqXIKO0lL6I7p3XIVA5kQL1Ai
         pbR1E5FNWRPLpbhQ4l2C/hyRP/x1gWXHZSr+Ez2KpELTLTP2jpT6rm+3c/Ihd2/WJXB/
         ZkxabwaVeGXw2BCW3lMsznQFuaOw2lxy7rvsqiTcrusgksAWKPPHep4mFy7N2ETvhJHT
         SY0+K3eoDX2jHEi2/YiUS0y/wTIY1lUCPca/UIb+vQKXk0/DU5iBo8Z/F/xpV0aJnjZq
         M3T0sUPOGGP46pRsVduREDkIFe0Asob8eeRhCF/eXg8GTYxQdoJesQau8YL97VzIHjws
         5/Yg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1781124857; x=1781729657;
        h=to:subject:message-id:date:mime-version:references:in-reply-to:from
         :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=cpHwfZUDsWSzZr9EiUqwUxTo6PjPMUtgi76bDXJ/v7g=;
        b=bnRc2hs4AHkOiYFdC+Q9UQeKRLGGtYJc7EoCxUX9usRww8VBaVYQrrK0dQlRZj0KqZ
         /0aBl1GePar3I+FqbU8bbclxwxMTxgFyuytMdmk2yp9WcKIpnY+Br7C3bhzdmKLrvYd5
         ieKvXAOnYZmtHQw6ViyQrrei0d+AHrFOVOuc5ctbSvGDTziVhGh0NFGrvo3Yx1WPxs3l
         1NZMXXtf/u5jVQgFIi8+hWBJyP5JCJ6ufrYqE4rv6V9iRaZzIdw+AQoKPCyG1lDk137T
         pICBJalvlYIB1BQ70w1ga+TxWVkoyXSvplIjV5iOx0DKpvla7aQJig8g1/l2Gmoafk8I
         68NA==
X-Gm-Message-State: AOJu0Yz8MeJnT0P575rHZ2wIEfMPHp/WZPXbGT7GU0CI2ML3HNsDe4VA
	0CE67bsh9////i2n46K6aKkmpOLlgiUsFBeWSBtuB7x5zqrUmrTqhaDcY74m1MA0ABXNP8RL4R0
	mpi576OYcJpopdXorSR2F6pDMmqHB3K17mxryKQ8UIkfCdJ0WMq4MLeIzSBGGCryE86u+gMFDmF
	kvAzzKQQFywlOQxwi00gYOSCA8MIHh99kOydEn2Z3hc2fGuIiuRIHuqaB4KLK6dlwbHRauVEH7c
	YkUAkKLE+KO6utNB6RVeSxrlBpxKfTEcMTXtn3d012nFG5SVAxeZpHYn6TWQa7qiKzENtSL5C+n
	xg==
X-Gm-Gg: Acq92OHSYD0OFBWes0ZGb4jKggAatwR6rmbSd453ddc4ckRuoVP+YNKmZlRm23gEhK/
	Cw03jDYMVYWXV5585Msp7Z3p3x4uRU6qN3ghCRqt4tZWvAWPaftDcKqu9u2HstkfK1TJEHaWfBB
	QOQLZgT5T5y15p9PAQkb3PCF34RE+gSsga+G+3l+KpBlqZlCRriX9W13L5Nkss5mcLFDwBXs50c
	AhHWuRlEMGiDls6nfBqqq1nhtvWLHnjeEzUK6MPx0EG9KdiVSeXqe41r/88juLUrGHGc+BPbXXH
	oUugWdmrl4p9V/hvPr4O4zaiGlaF4YzYec5nEjABIg7UTl1oMSRYz6FN2Cznc6NneyUKef1h69B
	uHbc=
X-Received: by 2002:a05:690c:6e02:b0:7ba:a726:57a4 with SMTP id
 00721157ae682-7f61a17c2d6mr9958117b3.36.1781124856586; Wed, 10 Jun 2026
 13:54:16 -0700 (PDT)
Received: from 298783833264 named unknown by gmailapi.google.com with
 HTTPREST; Wed, 10 Jun 2026 13:54:15 -0700
Received: from 298783833264 named unknown by gmailapi.google.com with
 HTTPREST; Wed, 10 Jun 2026 13:54:15 -0700
From: Zsolt Parragi <zsolt.parragi@percona.com>
In-Reply-To: 
 <CABdArM7x2cz9DiCHy-2n8PdScQex+qQQX7W7OLmA0rjWT8Sb1A@mail.gmail.com>
References: 
 <CABdArM5sw4Q1ZU8HGdo4BSc1A_+8xtUNq17j6wcir=yMUy19Cg@mail.gmail.com>
 <CAHut+PvnH8QHa035Skoh1e9jm_H08DO9fQ=F-NAMsEpYf0RZ2Q@mail.gmail.com>
 <CAJpy0uDu0LcNXcZCP0cR_LHqo+sau33KwPFHemmGVYf_JTxRBQ@mail.gmail.com>
 <CAA4eK1KbCWBmEXH-rhQjKgNwq=onZp8vRR-QkRhPpbKwL-kQdw@mail.gmail.com>
 <CAHut+Pvj4=GWoJEd4EBdp4pi6KxXQ46ioW=PV+=UktiXr2gCvg@mail.gmail.com>
 <CABdArM75F0A+DGP8AOt-_b_XREX40rvFid1jRjnr_+S5b51t8Q@mail.gmail.com>
 <CAJpy0uDTshb243L5yEYWB3uO-JrwSoRqQDNovh03K2GZuuR3Pg@mail.gmail.com>
 <CAJpy0uDy97ULmJUwPacAzc5u2seuPK6RXgCS1rnsW2MfR4eeSw@mail.gmail.com>
 <CABdArM6oXXXSAxxXFktTTfBf4kyxJCvdNtTbUZtSwJ=CepN+Xw@mail.gmail.com>
 <CAJpy0uBqM+fq7+g1ZRATuY16H10MFP9i25wfFCYCE5MGu+PE0Q@mail.gmail.com>
 <CABdArM4uKaS1coCQj6rAwMmHqU_cCJyEWNic-PFF1_ZjDDM82Q@mail.gmail.com>
 <CAHut+Pu5VNakf5JAhKM7T-P_q37eN1Qgv5nvZUe+8RAAT41y4g@mail.gmail.com>
 <CABdArM6WTm2gP4pcjVdHT1Nx6zdLKTq7nLPUkzZOhprc95a6Rw@mail.gmail.com>
 <CAHut+Ptthc1X-UA8-6zG-iFeCDuoNd+oJRBZ1eCnJ9RNOXjfBQ@mail.gmail.com>
 <CABdArM79m7-CTf6KGGGU2QBydFtuonGgfxRSqk-vhwTsH8z1ow@mail.gmail.com>
 <CAHut+PuiK_Pa=BkSgBxYzqf1PYh+mcUcUQCr8r1e69-y1r+hhw@mail.gmail.com>
 <CABdArM7rH+3GekRgufEOwrJxUeQk=LB182CQwJD35e0oN7q8ZA@mail.gmail.com>
 <CAHut+PtP1mbQT==xo=G-37dV9Lt3q7YO2eMEAqSbZuszy93LcQ@mail.gmail.com>
 <CABdArM6XRpUR86a-daYMXFqhH-spJQiQAVfJ2+GFiAqeup2jyA@mail.gmail.com>
 <CAHut+PuDB=doKUSf94cs8hOo2d5mOc+GxxPOf57xGhdE6e-Aog@mail.gmail.com>
 <CABdArM76MZ4dYC87zCv67fVY9t5aFLd2nD5tNBxFFizESyBOSg@mail.gmail.com>
 <CAN4CZFM9xXkw8FvHOTan+m4rASSoxbJTWXMbZ_-v2M-84w5Wzg@mail.gmail.com>
 <CABdArM5wj0dtieSVMvzvJDh5fJ-GGwh3PxV+E_MbPEntCk4KRg@mail.gmail.com>
 <CAN4CZFMaB1a89NZjRT9bWFZ8-XN02amye_fnYAg0NM_23DAwQw@mail.gmail.com>
 <CABdArM5qHR=Zmyfqs6AuCn-Crj=_w3CXA-1K9rQ53_zismXCNQ@mail.gmail.com>
 <CAN4CZFOaHBAUUrHmcCayUHVzcSw+SjWPEDuWT-5ij-KgxUP5=g@mail.gmail.com>
 <CABdArM7x2cz9DiCHy-2n8PdScQex+qQQX7W7OLmA0rjWT8Sb1A@mail.gmail.com>
MIME-Version: 1.0
Date: Wed, 10 Jun 2026 13:54:15 -0700
X-Gm-Features: AVVi8CcgZP8nVviN8bUBvglPoxWz9cHVwa1RYm0nuU-lb2A03Kr8NRVt2sv2F6Q
Message-ID: 
 <CAN4CZFMQGXpw-N-SbdCeSyJ-XjRJ9OckRKJUu3pFiJDf1c1-xw@mail.gmail.com>
Subject: Re: Support EXCEPT for TABLES IN SCHEMA publications
To: pgsql-hackers@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
X-CLOUD-SEC-AV-Sent: true
X-CLOUD-SEC-AV-Info: percona,google_mail,monitor
X-Gm-Spam: 0
X-Gm-Phishy: 0
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CAN4CZFMQGXpw-N-SbdCeSyJ-XjRJ9OckRKJUu3pFiJDf1c1-xw%40mail.gmail.com>
Precedence: bulk

> Let's wait for feedback from others.

Yes, I think that's the best approach for this question.

> Right, As also mentioned above, ALTER TABLE changes that affect
> publication membership currently do not emit any notice or warning, so
> I'm not sure we need one here either.

My idea was to make this change both for existing cases and new cases
in this patch, so it would be consistent, but that wasn't exactly
clear in my previous email, sorry about that. Similarly to how cascade
reports additional objects being dropped.