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: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Álvaro Herrera <alvherre@kurilemu.de>, Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, 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-10T22:17:26Z
Lists: pgsql-hackers 
On Wed, Jun 10, 2026 at 09:51:03AM -0400, Tom Lane wrote:
> =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de> writes:
>> I think we should just ditch the idea that operators live in schemas.
> 
> How would you do that without removing user-defined operators
> altogether?  (And thereby breaking most extensions.)

I am ready to estimate that the amount of existing users that would be
pissed after such a removal would be higher than the number of users
feeling safer with their queries after this operator capability is
removed.  All of them are probably already using their own search_path
for queries they care about anyway.
--
Michael

Commits

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

  2. SQL Property Graph Queries (SQL/PGQ)

  3. CREATE SUBSCRIPTION ... SERVER.