Message-ID: <36a1871d7ba625197c023ceb5118045786c6fe5f.camel@j-davis.com>
Subject: Re: Fix unqualified catalog references in psql describe queries
From: Jeff Davis <pgsql@j-davis.com>
To: =?ISO-8859-1?Q?=C1lvaro?= Herrera <alvherre@kurilemu.de>, Tom Lane
	 <tgl@sss.pgh.pa.us>
Cc: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, 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>, Ashutosh Bapat
 <ashutosh.bapat.oss@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>
Date: Tue, 07 Jul 2026 17:04:48 -0700
In-Reply-To: <ajBrndVqomlY_qK1@alvherre.pgsql>
References: <ajBrndVqomlY_qK1@alvherre.pgsql>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3-0ubuntu1.1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/36a1871d7ba625197c023ceb5118045786c6fe5f.camel%40j-davis.com>
Precedence: bulk

On Mon, 2026-06-15 at 23:21 +0200, =C3=81lvaro Herrera wrote:
> I am imagining that only database owners would be able to create
> operators.=C2=A0 There isn't any case for allowing that for anybody else,
> ISTM.=C2=A0 How much need is there for "less-trusted" operators, really?

That's probably true in almost all cases. Operators are generally
defined as part of an extension that offers interesting types and
opclasses, and these are C extensions anyway. I haven't ever seen
someone define a convenience operator like they might define a
convenience function.

Perhaps some use it for some clever hacks around unmodifiable
application code or something?

Regards,
	Jeff Davis