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 1wFi27-005SgS-2V for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Apr 2026 00:35:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFi24-00Foli-2S for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Apr 2026 00:35:04 +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 1wFi24-00FolZ-1K for pgsql-hackers@lists.postgresql.org; Thu, 23 Apr 2026 00:35:04 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wFi1w-00000002YmQ-3tpO for pgsql-hackers@lists.postgresql.org; Thu, 23 Apr 2026 00:34:58 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-89fc4147f2eso67964726d6.3 for ; Wed, 22 Apr 2026 17:34:56 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776904495; cv=none; d=google.com; s=arc-20240605; b=W1qeVALVcWkossyGJCAeXtsubpsj/AvewkIvd48t7Q5gsu/Fq8PGVgjnd6OrQ9oFPT GA2hVXuuAMVKsTd0G/UrhlXnI3hn7VSLRfkla/qQWajU33Y17MoSGyOoU4yl0GoxSKXb P3ElpHSwmgjhIBC9NikOC23xJwl0KTNKMtwxcycgYxUG1p+uqGHh4aq+kzeFK0C9fXTA EL7ErS+pGI/tpA69Lfraq4ZumXhlVBylAhrf22WZYAK2aLrtPqWfyXLL/teTNMhcVEuB I7mzkRPk7DJ34RJlLmM5F6W0R/29qrOthHOncWpGifuPr1CXuf3aT2jByZfd+9k6VjaF jO6g== 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=daRXSVaoTKQodE5+2gxiYNUSkzXppUNcEso8EDGJDLU=; fh=8Z6ywrksHgupb34dgyNU9gM4kpWz8OB4UbUH6C1AfYA=; b=OMtLTO+RFjMxudYqG0P+75/z6VdUDFIhkCNigykN7W2qMW3Zi2+Rdj4Bz4wAnFAw1o n3Nea34H0JwpHgPW2/CsTlC/lfVD7oTzvrpBeK/Nf+Z0ryVtbGXyVXvpAKiDt15KcEBM 4EnkQqlMq2pGddN/4fqcxIsJeD1piIMSLkuQMYBwbfCYVujY9ljr8/hAU6savEGMkSxk 0S43c5Yy2PKlUP5bNMouT7gigNpT857+4uvC8Dfasq8Me/nriwzi6BT+QTUQWGTk8o7d e58QDlqE+U0pTnv4DKurI6mRIaElYftryZ0SfEZtXKJaw5BOotOSqdZFYmlMftAfbGFB Nhlg==; 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=1776904495; x=1777509295; 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=daRXSVaoTKQodE5+2gxiYNUSkzXppUNcEso8EDGJDLU=; b=fwru4txwZCrupnlLX+FeVYr2CV8p9Ww4Zxb+o+YVaXZbIvx8hoVV0frNMBMumbYh5h K48zOTCYL05gUyyMn3gmpksTX1k1fMkR577ELyfh6k2hAGOMVn5XPq4eMDfjbrD2Rl4b InSCYLDCDW90TbPVt4Iidr88lOCo8gLaCf9Gwo+Yy+WyYNwSam3/alCWXB4qKO8e30on 8rVQRcmZIxRMa33Grv7RahYS195gQVygidpBs9+Ou4BnqHIsX7fcOat9dT0nqR62ORF4 bZbaOrCHrKiE/9sEO5pe7cJntuSgLqJI+0w+lacBc+3VAoxM//+1CZnnkoDGuo0YuwPw 3Byw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776904495; x=1777509295; 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=daRXSVaoTKQodE5+2gxiYNUSkzXppUNcEso8EDGJDLU=; b=i1vMxm6s0zglT2UZ47mEbrZBojQ7l+BvqjY71kW5cBhHktwZCs7QLCE4pLzeLg8Xhp VcvNA10yDm33MPZn3RGVGgfkD1K8oJPFuGKHHDRWXysxPNhO4sm29U1DdKK/4eguU9JO kXcpHXqXEHyUNV5M6qq12kejAQ0dWKJpVvnFuxEAACVbidZCEkua1Cp6X8eraG5vivRn 6KrgajvcytdtbugM6QKGp9C9RTdCZMKDPLU0Y0Q6aYxLURm3qpHVX61jy1Tec8pisQWr 8i2E0qExGR1Fvolt5tExOj9F4qZGZfXzG6YPhMy1ea4AaPIcsI0ZCu2j/Du1kvDwfoNo U9Hg== X-Forwarded-Encrypted: i=1; AFNElJ8TGq/OoU/nGHzXz3f4bnxAAlXCOaHA+QRgMpV8oYNrjepPJvEYhDgy6Lw8atPj0w9HRZ08Bjlq6g0AW+km@lists.postgresql.org X-Gm-Message-State: AOJu0YzSjhkcevlhgZrXU9rYI0dqO8F3xQIQRrChQ03yb2Zeztsd9dD0 bk0x+Wju8kIcb3fajgoyaUqxjRoQFbWl7oM6K0LyYknlKX0Fu/fPIcbY2uWz5bnaTDhEwhumdKA sKIcJG0B5vahAlRNAq/Z+Yhi3Uvl32F8= X-Gm-Gg: AeBDietGQ3kDdqo1ihN7wqArPxINiBnkpAO9Ggv4LKdzdWlkTQwCHxkhXVSyxYH0j8N nxbHDQ4DFdnfX2DcCf1vaU9ADgYU/JOejUMu5K/SlZwYkaJW7o/i7gH+BrcuAi2/F35YOvCW53K S3exVkJnpEtS31BKVN6I8XvnpdsJOqBjX0Ao7QOqilBglDDtla1p7XzuAcsGdR9r3/mUrs+xMzc Qr1zgyFz0vit+NEfr6hbCgkpUb4u8Sg325tzMUJHxK+I8I55TY6qZXr8m6at2NtbOxoCHco7L33 hyvnomrszm7H13v68EMSYgF7YYfK X-Received: by 2002:a05:6214:8008:b0:8ac:6f8c:a9b with SMTP id 6a1803df08f44-8b028059d56mr328614716d6.17.1776904494513; Wed, 22 Apr 2026 17:34:54 -0700 (PDT) MIME-Version: 1.0 References: <4ff427ca-7986-4d13-820f-199672ab81ff@163.com> In-Reply-To: From: Peter Smith Date: Thu, 23 Apr 2026 10:34:27 +1000 X-Gm-Features: AQROBzD-p_amau1-hHL_XHB9IcGr2zvLnJT4c7mpUk3PiEjKbcF4BI6Z8HCWdj8 Message-ID: Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+ To: Amit Kapila Cc: Yuchen Li , vignesh C , =?UTF-8?Q?=C3=81lvaro_Herrera?= , 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 Wed, Apr 22, 2026 at 9:27=E2=80=AFPM Amit Kapila wrote: > > On Tue, Apr 21, 2026 at 12:16=E2=80=AFPM Peter Smith wrote: > > > > PSA v4, now combined as Vignesh suggested, and with the extra space als= o fixed. > > > > I would like to explicitly mention in the commit message that "Tag for > included publications was a pre-existing behavior but it is better to > change it for making it consistent with excluded publications tag. So, > how about a commit message as follows: "psql: Improve describe footer > titles for publications. > > The psql describe (`\d`) footer titles were previously unintuitive > when listing publications that included or excluded specific tables. > Even though the tag for included publications was pre-existing, it is > better to update it to "Included in publications:" to match the > phrasing of the "Excluded from publications:" tag. > > Footer titles for sequence and schema descriptions have been updated > similarly to maintain consistency." > > -- OK, but the order what happened was a bit different. 1/ Firstly, it was only the "Except publications:" footer for \d that was unintuitive. So that was updated to "Excluded from publications:". 2/ The pre-existing "Publications:" was intuitive as-is, but it was updated to better match wording of 1. 3/ Then footer titles for sequence/schema were updated same So maybe reword it slightly something like below: SUGGESTION The psql describe (`\d`) footer title was previously unintuitive when listi= ng publications that excluded specific tables. This has been fixed to say "Excluded from publications:". The pre-existing footer title for listing publications that include specifi= c tables has also been modified to to better match that phrasing. Now it says "Included in publications:". Footer titles for sequence and schema descriptions have been updated similarly to maintain consistency. =3D=3D=3D=3D=3D=3D Kind Regards, Peter Smith. Fujitsu Australia