Horton

Re: Allow database owners to CREATE EVENT TRIGGER

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Steve Chavez <steve@supabase.io>
Cc: Aleksander Alekseev <aleksander@timescale.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2025-03-05T14:58:26Z
Lists: pgsql-hackers 
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.