MIME-Version: 1.0
References: 
 <CAHut+PvSOmRrQX+VrFYHtFipV9hM=p99FeOwYCzkuU2BOaLu7Q@mail.gmail.com>
 <5420ddcb-7b55-4a73-b8c5-3602abfac78b@uni-muenster.de>
 <CAHut+Pturr_EY3WgVMT5+rrcKLm9HcRCk5X0WH8zvwtD2K2ixA@mail.gmail.com>
 <1b1c88ce-2c61-4faf-b647-496525fc177f@uni-muenster.de>
 <CAHut+PvfAQQTaV4qQzivBx_LLhveA0h=ugy_MRRR+NjwndNPgg@mail.gmail.com>
 <CABdArM6Ls0DRkqmpg5oDjwJhkrC9rvUQ9+y1jNmwRG+cq57cVQ@mail.gmail.com>
 <6071d0a2-a02d-4fb8-bdec-1991411d4a9d@uni-muenster.de>
 <CABdArM4_=HZjkQAxy5OA2u0h+ZLCacQGNQREot8-nXJ2QNTgbA@mail.gmail.com>
 <CAHut+PtecJnFckGxEMT0-yhW=nTDR9aVcWpn_G+rFWTLTkP=YA@mail.gmail.com>
 <CAHut+Pt0v3v6BBUhh774ScpzqCaXu-LXwZd_1tMh_0Ftktv3vg@mail.gmail.com>
In-Reply-To: 
 <CAHut+Pt0v3v6BBUhh774ScpzqCaXu-LXwZd_1tMh_0Ftktv3vg@mail.gmail.com>
From: vignesh C <vignesh21@gmail.com>
Date: Wed, 8 Jul 2026 16:36:20 +0530
Message-ID: 
 <CALDaNm3Cf9vYAFa3XYHMjJSaaXaZygKxgc7bahMrC2JBvA7pKg@mail.gmail.com>
Subject: Re: PSQL - prevent describe listing tables that are already in listed
 schemas
To: Peter Smith <smithpb2250@gmail.com>
Cc: Nisha Moond <nisha.moond412@gmail.com>,
 Jim Jones <jim.jones@uni-muenster.de>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CALDaNm3Cf9vYAFa3XYHMjJSaaXaZygKxgc7bahMrC2JBvA7pKg%40mail.gmail.com>
Precedence: bulk

On Wed, 8 Jul 2026 at 04:58, Peter Smith <smithpb2250@gmail.com> wrote:
>
> A rebase was needed.
>
> PSA v7.

One minor comment:
Can we add a comment here too, similar to how you have added for
describe publications:
@@ -3048,7 +3048,12 @@ describeOneTableDetails(const char *schemaname,
                                                          "FROM
pg_catalog.pg_publication p\n"
                                                          "     JOIN
pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
                                                          "     JOIN
pg_catalog.pg_class c ON c.oid = pr.prrelid\n"
-                                                         "WHERE
pr.prrelid = '%s'\n",
+                                                         "WHERE
pr.prrelid = '%s'\n"
+                                                         "  AND NOT EXISTS (\n"
+                                                         "     SELECT 1\n"
+                                                         "     FROM
pg_catalog.pg_publication_namespace pn\n"
+                                                         "     WHERE
pn.pnpubid = p.oid\n"
+                                                         "       AND
pn.pnnspid = c.relnamespace)\n",
                                                          oid, oid, oid);

Regards,
Vignesh