public inbox for [email protected]  

help / color / mirror / Atom feed

From: Peter Smith <[email protected]>
To: Álvaro Herrera <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
Date: Fri, 17 Apr 2026 09:03:38 +1000
Message-ID: <CAHut+Psq7qmQSQCZA_HZcFv9ADCHDUPqCyFuTKfPDU-GUGihhQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAHut+Pt3t_tCYwDStkj5fG4Z=YXrHvPBA7iGdh745QipC5zKeg@mail.gmail.com>
	<[email protected]>

On Fri, Apr 17, 2026 at 12:10 AM Álvaro Herrera <[email protected]> wrote:
>
> On 2026-Apr-10, Peter Smith wrote:
>
> > # -- describe the tables
> > # \d t1
> >                 Table "public.t1"
> > Column | Type   | Collation | Nullable | Default
> > --------+---------+-----------+----------+---------
> > a      | integer |           |          |
> > Except Publications:
> >   "pub1"
>
> I have a hard time understanding what an "except publication" is.  I
> think this would be clearer if the header said "Excluded from publications:"
>

I agree that your suggestion is clearer.

If we make that change, then should the "Publications:" footer also be
modified similarly (to "Included in publications:") so they match?

e.g.

CURRENTLY

test_pub=# \d t1
                 Table "public.t1"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 a      | integer |           |          |
Publications:
    "pub1"
    "pub2"
Except publications:
    "pub3"

~~~

SUGGESTION

test_pub=# \d t1
                 Table "public.t1"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 a      | integer |           |          |
Included in publications:
    "pub1"
    "pub2"
Excluded from publications:
    "pub3"

~~~

I will wait for more opinions/consensus before providing a patch.

======
Kind Regards,
Peter Smith.
Fujitsu Australia

view thread (19+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
  In-Reply-To: <CAHut+Psq7qmQSQCZA_HZcFv9ADCHDUPqCyFuTKfPDU-GUGihhQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox