Postgres Pro
Downloads
Home   >   mailing lists

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 CAKFQuwbgjvupHPFjdGVz-T2miawVP=W3FN=KQdPvTSNtAbP-0g@mail.gmail.com
Whole thread Raw
In response to Allow database owners to CREATE EVENT TRIGGER  (Steve Chavez <steve@supabase.io>)
List pgsql-hackers
Tree view
On Wed, Mar 5, 2025 at 7:55 AM Steve Chavez <steve@supabase.io> wrote:
How about requiring explicit non-superuser execution for the database owner evtrig? It would be like:

CREATE EVENT TRIGGER name ... FOR NOSUPERUSER;

This is more what I was thinking - which works for a boolean.  The ability to have an exclusion list would make sense, or maybe just a predefined role pg_bypass_eventtriggers.

David J.

pgsql-hackers by date:

Previous
From: Sami Imseih
Date:
Subject: Re: should num_custom_plans be reset after plan invalidation?
Next
From: Álvaro Herrera
Date:
Subject: Re: Non-text mode for pg_dumpall