Re: Fix unqualified catalog references in psql describe queries

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Jeff Davis <pgsql(at)j-davis(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: Re: Fix unqualified catalog references in psql describe queries
Date: 2026-06-09 09:08:50
Message-ID: aifYIhmiqNr9mf6f@bdtpg
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Tue, Jun 09, 2026 at 04:08:26PM +0900, Michael Paquier wrote:
> On Mon, Jun 08, 2026 at 04:46:46PM +0800, Chao Li wrote:
> > This is not a big problem, but it provides a way to pollute the
> > result of \dRs+ by adding a fake pg_foreign_server earlier in
> > search_path.
>
> Which is always annoying.. Will fix and double-check later, thanks.

Now I wonder if we shoud not "protect" the operators too. They could also
lead to wrong results (if not worst).

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Akshay Joshi 2026-06-09 08:58:15 Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements