Re: Allow database owners to CREATE EVENT TRIGGER - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Allow database owners to CREATE EVENT TRIGGER
Date
Msg-id CAKFQuwZaW21Td4gK92wNYhFo4j7mxAA3XZjptzgcA3V=9xwZYw@mail.gmail.com
Whole thread Raw
In response to Re: Allow database owners to CREATE EVENT TRIGGER  (Aleksander Alekseev <aleksander@timescale.com>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible
Next
From: Aleksander Alekseev
Date:
Subject: Re: Allow LISTEN on patterns