On Wednesday, March 5, 2025, Aleksander Alekseev <
aleksander@timescale.com> wrote:
> Unlike superuser event triggers, which execute functions for every role, database owner event triggers are only executed for non-superusers.
All this doesn't strike me as a great UI.
Yeah. Seems better to make “execute_for” an attribute of the trigger and allow both superusers and non-superusers to create them. Then enforce that non-superusers must specify the more limited value.
Though it would seem nice to be able to exclude the pseudo-admin roles these service providers create as well.
David J.