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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Peter Smith <smithpb2250(at)gmail(dot)com>
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-12 12:53:55
Message-ID: aiv9oBhW8mL_F8Yn@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2026-06-12 13:02:37 Re: Fix ALTER DOMAIN VALIDATE CONSTRAINT locking
Previous Message Chao Li 2026-06-12 12:45:00 Re: Fix ALTER DOMAIN VALIDATE CONSTRAINT locking