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 1wEhRg-004J4V-18 for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2026 05:45:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEhRe-000lxE-0f for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2026 05:45:18 +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 1wEhRd-000lx6-2y for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2026 05:45:17 +0000 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wEhRb-00000001sME-3nrA for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2026 05:45:17 +0000 Received: by mail-lj1-x233.google.com with SMTP id 38308e7fff4ca-38e7d983f50so28990011fa.1 for ; Sun, 19 Apr 2026 22:45:16 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776663915; cv=none; d=google.com; s=arc-20240605; b=X2BvdgZMx4yG7zNGUwtiYuB8RXNXHGq4YnggsDCmZfpp3ibsAlT3iuKGBu18400ldv q//cgOGoYMo+/F4BvC7FpHNl/nTjGrDzVP9jIO1gwS/WrT7HX0yIS63uptqWvGAt8I2P avx5kGMrIFTcmKjK4T2gFN87UZ1VSLt1rVNvZFTPW5ftSRlWECbPmz1RGZO9rYX2SmfG LpECwoVrX7FutUTHRuUU4NYM5Jq0kKS7bomHf4xZ4KAeRmDQFw4O5gF+1JGVh/GrUveI 7sLwxUBD3Hqe3R2frSdNUiMO4kEqWYotaUlegSXenPgLSmQv1M6q5BEdgN8l+kbGsvM3 oeIA== 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=L6uvxQdQgHn4X55T2b42/fBMORLuJVqtWoD5mooI8eI=; fh=KcfTCw2ZVqAV+lTGR3KRT9q1CRnyXcs7hTtvM0Hb+1I=; b=RGx5UbCIGWHDPJff7Oj1p5J1ZShWUzZxtuZxifyUPQv9vnyFW9Dil6X+/AzjVtkFgz Tlav+Z4dFmBlq8UlP6kQjl5HPCx+Q7AuU55h8giepfW0s8n2j/ZZrVJ2vMKEm6+ON8fK tbKvoJ/Xj1micVfzssLIemA/c6j+kAkQUQiTWg56yLjztneAe1PCJwEKK7jetUqeEN+B V7AWOae+jjYHcHinPPBHke2VYunDCN2HQSik0OmLqjZ25bVLQGbiPRGewiXKorCqh45J JoJTf3t1657P8I1JGbmtl1hZnldddbSFKNpZeoEG3Tj7kwSbmfWKtbyMFrzazt/5d/MZ kZBA==; 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=1776663915; x=1777268715; 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=L6uvxQdQgHn4X55T2b42/fBMORLuJVqtWoD5mooI8eI=; b=jm6WalPARh9WGqDHtekRsY6j6XIiseCXoHe6tSh0Kez+hF7P5qu4edO0/GPFxJ0a4G 2pYymNp1hcMtwJWYqnqdLdtF8wIOJRl6wheEkiQOW12Gz6QWhapY5yRkZUdfUEkCLTA4 b4wSECqhgRFJRgaHObgui/Lt07RnoymN8GW+8TxNMopqZnkQsciNUcScf6JfsJVStTYi 8N8TwJ+scISSMp7PgOxL7c9kuzr21ZnCR6w4SuTRoGmz+Dk2IgoE85WK9DktdlWyv6No 4hr/yl/cJn+FwSz55XYngB5ExIOm+dqteeOFkgJW2g0nWhxjQUfJuPOOfXY2gIHffVoa PYdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776663915; x=1777268715; 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=L6uvxQdQgHn4X55T2b42/fBMORLuJVqtWoD5mooI8eI=; b=Ddhk+9DDGDRgGNGdffdY3kqn/cfKjB2BYjeLwFQSwvH614D/XEgkCo9abUapODdXu4 5WTcaj8/VB8KcT73Zk4tabFqvuJ2YAcerJ1FWkSFeUsKfas/DmjTgI3j9qPU+Qo+lW0h hrgq8oA4WYVg6c8RfFgvNpnsTIIL10eEwyTrCW90RCqKlli9eFlw2cPg8pld4kkXlxp7 ITcFWOo6u6GMxtoCcgegEDW+PYx1u8Dxc4Cdks61hd3bZvQ/SQzRF+4l2xKmyQhGH0go s1a5Jgfq2CA3GYxbGskgdX99Uc130GVAtb1mU6UNG4x//yKx/2lv3yY1El/rsjB8g5qV nJvQ== X-Gm-Message-State: AOJu0YywEHCQ+k5fLXxwL2N+Sd4y+oPo6yNbinLmhFOeFeXa4E9CXkNO cwsilUiXIHPIh5AAY/bHvsB2vatZuwYYPJnBz6m8yz2TgS49XvxppUouFRXmKEmh5edYjMAMaS6 umQ5wNd8Se2czkbhlSfxmoq+BlbaugwQ= X-Gm-Gg: AeBDiesaROghalfju41bEJA8oYBBD3DPyvECXp1oV2SrI2Hqfu96KBGXwsjOUww4xLi Gf+F7iRYN5StNL0GkVVbhtcCfQMe8GxDwmOgT2lfBtSQReQGjbP4uFXJnna84+EMTc4gKSmzmj3 lja6T9VCV9CWz6LWl6wVRFbkhqHcoF/U7ae0QlWcclVJyWUnutrrg37VbULKBnzDCUuePX5oZha k/K+lOwPzYFWrSzlOyzCreTpDKhPPeTyk5r6U+e9QNC3a4soajqO3TcYvM/aBmIiOMGf65sqPd0 Qoz1U7QehNNCQpP23f5dykwriQ0OK12lnaJKdKa8eJoviDMwMWKeNLFfe3oZKOE5tqfobze2XK0 lkvB0HkI5 X-Received: by 2002:a05:651c:2556:20b0:38e:1da0:916c with SMTP id 38308e7fff4ca-38ec783c502mr25289711fa.13.1776663914290; Sun, 19 Apr 2026 22:45:14 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Mon, 20 Apr 2026 11:15:02 +0530 X-Gm-Features: AQROBzDYk0f8015nmXq15crg9cDP77RBk6WbSlB8JnyViQfG-nn6M4wTHs00-aE Message-ID: Subject: Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY To: Peter Smith 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 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 effect > > > 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. --=20 With Regards, Amit Kapila.