On Tue, Dec 13, 2022 at 7:49 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > Michel Pelletier <pelletier.michel@xxxxxxxxx> writes: > > I'm working with an event trigger that fires on ALTER TABLE and regenerates > > certain objects, but unfortunately those objects end up being owned by any > > extensions that run ALTER TABLE and any subsequent alterations fail to > > regenerate because they are owned by that extension. > > > Ideally, I'd like to be able to detect inside my trigger if I'm being > > called from CREATE EXTENSION or not, but I can't find any obvious way to > > detect that. > > At the C-code level you can check the creating_extension global variable, > or maybe better look at the in_extension fields of CollectedCommands. > > I don't think we expose that state at the SQL level, but it's pretty > hard to make a useful event trigger without writing any C ... AFAICS it's exposed in pg_event_trigger_ddl_commands().in_extension.
