On 6/21/19 3:07 PM, Stephen Frost wrote:
> When it comes to cases that fundamentally are one-off's and that we
> don't think really deserve a proper DDL command, then I'd say we make
> the extensions set the flag. At least then it's clear "hey, we had to
> do something really grotty here, maybe don't copy this into your new
> extension, or don't use this method." We should also un-set the flag
> after.
I'd be leery of collateral damage from that to extension update scripts
in extension releases currently in the wild.
Maybe there should be a new extension control file setting
needs_system_table_mods = (boolean)
which means what it says if it's there, but if an ALTER EXTENSION
UPDATE sees a control file that lacks the setting, assume true
(with a warning?).
Regards,
-Chap