Re: PSQL - prevent describe listing tables that are already in listed schemas

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PSQL - prevent describe listing tables that are already in listed schemas
Date: 2026-06-15 02:01:48
Message-ID: CAHut+PvaHNdgHoCfTq9K60PJpe_L7M3sswgiDe2R=XVEaOfapg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 12, 2026 at 10:54 PM Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:
>
> On 2026-May-21, Peter Smith wrote:
>
> > The new tests in patch v5 look good to me.
>
> So do we want to consider this a backpatchable bugfix, or just a
> new-feature-ish quality of life improvement? If the former, then we
> should probably backpatch it; otherwise we would normally wait until
> pg20 opens. Though to be honest I would also consider this as
> borderline okay to include in pg19 for beta2 -- especially considering
> that the output in 19 is already changed by the EXCEPT TABLE listing
> additions.
>
> Given that it applies to servers back to 15, that means that in the
> situation where it applies, pg19's psql (or pg20's) output would be
> different than earlier ones given identical database state. I'm not
> sure that would be really great.
>
> What do others think?

FWIW, when I wrote this, in my mind I considered it more like the
"quality of life improvement" because it is mostly about not
displaying redundant information, rather than fixing any major bug.

AFAICT this is quite an old problem that nobody ever found/reported it
before, so even though I had intended this for PG19 (and posted before
the freeze), it is fine by me if you prefer to leave it until PG20
because I don't think anybody will miss it.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-06-15 02:46:36 Re: Use \if/\endif to remove non-libxml2 expected output in regression tests
Previous Message Henson Choi 2026-06-15 01:56:12 Re: Row pattern recognition