On 2026-Jun-15, Tom Lane wrote: > =?utf-8?Q?=C3=81lvaro?= Herrera <[email protected]> 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/
