Horton

Re: Fix unqualified catalog references in psql describe queries

Álvaro Herrera <alvherre@kurilemu.de>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@kurilemu.de>
To: "Bertrand Drouvot" <bertranddrouvot.pg@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Michael Paquier" <michael@paquier.xyz>, "Chao Li" <li.evan.chao@gmail.com>, "L. pgsql-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-10T08:33:35Z
Lists: pgsql-hackers 
On 2026-06-10, Bertrand Drouvot wrote:

> I do agree that doing so would "destroy" the readability. I did not 
> look in detail,
> but what about forcing ALWAYS_SECURE_SEARCH_PATH_SQL before the queries 
> and
> restore the search_path once the query is done? (that way that would 
> not impact
> the readability)

I think we should just ditch the idea that operators live in schemas.

-- 
Álvaro Herrera

Commits

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

  2. SQL Property Graph Queries (SQL/PGQ)

  3. CREATE SUBSCRIPTION ... SERVER.