Horton

Re: Fix unqualified catalog references in psql describe queries

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Cc: Chao Li <li.evan.chao@gmail.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>, Fujii Masao <masao.fujii@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, Jeff Davis <pgsql@j-davis.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>
Date: 2026-06-10T01:57:16Z
Lists: pgsql-hackers 
On Tue, Jun 09, 2026 at 09:08:50AM +0000, Bertrand Drouvot wrote:
> Now I wonder if we shoud not "protect" the operators too. They could also
> lead to wrong results (if not worst).

Kind of true.  Still we have been pretty lax about the operators as
they also lead to less readable queries.

There was one spot missing with string_agg() two lines down one of the
pg_get_expr() changes.  The spots for relation and function
qualifications are worth addressing anyway, and consistent with the
file style.  Fixed the extra spot I have noticed, and applied the
result on HEAD.
--
Michael

Commits

  1. psql: Add some missing schema qualifications in describe.c

  2. SQL Property Graph Queries (SQL/PGQ)

  3. CREATE SUBSCRIPTION ... SERVER.