On 2026-Jun-15, Tom Lane wrote:
> =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.de> writes:
> > My proposal would be that all operators, both system-defined as well as
> > user-defined, live in a single namespace -- not that we forbid them from
> > being created.
>
> Exactly how does that improve anyone's life? It will certainly not
> improve query security, rather the reverse. You could no longer put
> less-trusted stuff into a schema that's not in your search_path.
I am imagining that only database owners would be able to create
operators. There isn't any case for allowing that for anybody else,
ISTM. How much need is there for "less-trusted" operators, really?
As long as it's not restricted to superusers, there is flexibility
enough.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
