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 1wEitS-004KcH-17 for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2026 07:18:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEitR-001Daw-1Q for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2026 07:18:05 +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 1wEiqM-001ARr-1r for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2026 07:14:54 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wEiqK-00000001t26-27Rp for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2026 07:14:53 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-50e63771d91so3284901cf.0 for ; Mon, 20 Apr 2026 00:14:52 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776669292; cv=none; d=google.com; s=arc-20240605; b=K26n2Q7gfu8Yopb2FQ0yGnGByeyXhNvUgHcT/h1jQK7rAW+JHXA3Qm0F3h49muhkmB vZmlqGJ7EWQFFUKD68jUroo7DAkng0evBsxCK7NOc/ebVQPiVRIsTBwglJLy1Ar3CBoT 56VDQHk63SxfA2NPWryJvWejmpk2QD/fF/eL9iO1i7caT9oJSKEhDDU7oEcewgXTU8Xo NufnH5+ELQHIgSsOwnp70YrB3RqNQTbxq5FwnJIOFNUqS/EWws1dd/LSxXrJI2lEPe8S c91q6LnzebvdIToyU6UDkqvgdJiITF6D3IpO++9xObcQPdh4Orz3TmEJ6enTMo1Wh/zP yHiw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=4wYO1pDkxtcQ7SYebhhLWZdLHC5Gn0djgXI05osp5eo=; fh=99cPETC/63IsvQoFoENkZwbGQFmSkW+Huy3VpGrhYuI=; b=MbV64aFUp34KMVHb/pVPi6ldeM+T3Fc3lleKct9nPg9BiZzLqjdETJ1Ad2G11WYsr5 LhKEm8U/IH4ROiKImerJCxAhfhytsXpZKDu4vPaySLO4d1PteyPTV6Bo5A/2ShGcVDoj uVDxYRO6AWnHvbKd/aJiTnQGP26kgmXo2y3FbEC8MZHf96suNwr8SpXDlRMP9V3kb0BV KisCVUMfbKVcUcxGCnmj9WrZnzf/4Jwnrr7Nu3YJPIqkqrm73w0ey0QBB7ZEEAwXLKcV zaZCFQ4RuX/NqhpixIFlUhU+iyDG4/nVr868bCf9r5g2+Yskj2QVD1WwTi3SWKhSPufQ zryg==; 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=gmail.com; s=20251104; t=1776669292; x=1777274092; 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=4wYO1pDkxtcQ7SYebhhLWZdLHC5Gn0djgXI05osp5eo=; b=cHAyVnNEcOfffulF447hQTqMEiZffowpYO93cDSRKTgRdosIcCWe+c5uKWkXlv/RFP BVkPunDZLn8/5xaf6sXiafinDKOE2kFhYYLlR/s8GcF4xROmdM07Sg5C8IVApB6lgimR 3swQYt4XTzk3domsRo5i+tb8mg4BWMd6ygjIdH/2qa0Luw8HvVOE3KGfMA2gf2pquB6J iPBX/bHCz6I80HSMApFU8MZJxZqcp2q97AUTzSVbZnfQ+9LPStl9QSIIzNuf26dKLe85 oGW29UuOGtHO0q3GdP6hSzHq4+4a9jE+LEEq/fYsITIcuOgsvdoLFLjqsP3Ooz71SKjr GZXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776669292; x=1777274092; 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=4wYO1pDkxtcQ7SYebhhLWZdLHC5Gn0djgXI05osp5eo=; b=FQKD+afBApIucSFUfyVS4y4vnGI7tNB+20JUsY3v6nlAyxIRTaUgtjlSw4ADbZiPe2 n7aeEcceQPSAR8+n70qJdA/mqlsAbwGKDVQTQ/T1X96awxkcIUsWrG8E5ajJlhuRWkJA Nq9TCq2zIl//JzK4wkSIKxtndcgSlhHWOC4vmciDO6nerry4xMUld17Qng3NaRwkOkF9 1/rH2jQidWeBFSqKmEDtb3O1e1iMNP/VKP6t9fa5ojF5aWeHf24/8rnuDM+f8+n6pFVD EkQLqh1SRuzqZwHL/NJo9sTPGnF0g9FCdTnpTYECARH66AN0OKvdsAfkv5dZ5Caeh5c/ la6A== X-Gm-Message-State: AOJu0YyzIIKCpc+sIv+d7qBFojapVTrXCwpE29tzlhXZ9/rGIv/5HZ1N 64VfeiCk9BqRxSVNx0KhnmDps9mYMwz+NBNp5hDy9sEVSauNCsCXt7Jjs9Shprznfmk5BF2/E/J DbgmODBBrWfntVwZyOFNXt+WGz9cszY8= X-Gm-Gg: AeBDietrf30Tp9BdKgEGOxNkzCoB3vjGjO+hul/tEaP3Pisu+PeCA6JtIAvCkxphrnG 69De6kMgTcv42R7lhKn4OpyxeDxGL7CrHr84o/His1gGosEUIVqcQY9M0iYLqOSl42BCql7UhTu jUjQwsgofLsLPxb71J00QFF2TVcWkt/JRlktyTTeeCyZ+ummg8522xm+eE4q+4EEPOBU7Z+Zqaf v4VXjnc9+jf6O83Bl0mZYAnpqthe9Y4y7n4BDDD9hhUOg630kDXFgiUFI6uRbDsJZCowN/BxA0O LUuYQZ5gSdpJaQoeuw== X-Received: by 2002:a05:622a:7e4b:b0:50e:5cea:a519 with SMTP id d75a77b69052e-50e5ceaa60dmr35131831cf.12.1776669292104; Mon, 20 Apr 2026 00:14:52 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Peter Smith Date: Mon, 20 Apr 2026 17:14:25 +1000 X-Gm-Features: AQROBzDUtpSdUtqUa1XJG4XMcqDuUcIxxCmGh0wUIeXL7bbcAU-u4MEECE2TfD4 Message-ID: Subject: Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY To: Amit Kapila Cc: PostgreSQL Hackers 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 Mon, Apr 20, 2026 at 3:45=E2=80=AFPM Amit Kapila wrote: > > On Mon, Apr 20, 2026 at 5:44=E2=80=AFAM Peter Smith wrote: > > > > On Fri, Apr 17, 2026 at 8:44=E2=80=AFPM Amit Kapila wrote: > > > > > > On Fri, Apr 17, 2026 at 5:26=E2=80=AFAM Peter Smith wrote: > > > > > > > > Currently, the EXCEPT (TABLE ...) part mentions how 'ONLY' and '*' > > > > work for inheritance tables, but how they have no effect for > > > > partitioned tables [1]. > > > > > > > > It seems we accidentally missed saying that these also have no effe= ct > > > > for *regular* tables. > > > > > > > > > > The sentence you quoted speaks about partitioned tables specifically, > > > so not mentioning regular tables there seems reasonable to me. > > > > > > > I think you missed my point. > > > > No, I understood the point but didn't find it useful to add this to > regular tables because they won't have children in any form. > Because regular tables won't have children in any form, a user could reasonably worry that saying ONLY or `*` might give a runtime error or a warning. There is no documentation to say otherwise. The patch addresses that gap. =3D=3D=3D=3D=3D=3D Kind Regards, Peter Smith. Fujitsu Australia