On Mon, Jul 10, 2023 at 11:04:48AM -0400, Tom Lane wrote:
> ISTR that we discussed forbidding such changes way back when the
> extension mechanism was invented, and decided against it on the
> grounds that (a) it'd be nanny-ism, (b) we'd have to add checks in an
> awful lot of places and it'd be easy to miss some,
The namepace modifications depending on the object types are quite
centralized lately, FWIW. And that was the case in 9.3 as well since
we have ExecAlterObjectSchemaStmt(). It would be easy to miss a new
code path if somebody introduces a new object type that needs its own
update path, but based on the last 15 years of experience on the
matter, that would be unlikely? Adding a note at the top of
ExecAlterObjectSchemaStmt() would make that even harder to miss.
> and (c) forbidding
> superusers from doing anything they want is generally not our style.
Yeah.
--
Michael