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. I hope this isn't obvious and I just missed something in the
documentation. Does anyone have any pointers or hacks they know of that
can accomplish this?
Thanks,
-Michel