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

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Peter Smith <smithpb2250(at)gmail(dot)com>
Cc: Álvaro Herrera <alvherre(at)kurilemu(dot)de>, 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 06:36:33
Message-ID: CAA4eK1+e-a2nEA-fzQcE91vu8XpEC62R7tshPC14gp-jX1mqYg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 15, 2026 at 7:32 AM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
>
> 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.
>

+1. I also feel this should be considered as an improvement for PG20.

--
With Regards,
Amit Kapila.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2026-06-15 06:43:36 Re: Fix SET EXPRESSION for virtual columns with whole-row dependencies
Previous Message jian he 2026-06-15 06:32:01 Re: Row pattern recognition