Re: Allow database owners to CREATE EVENT TRIGGER

Aleksander Alekseev <aleksander@timescale.com>

From: Aleksander Alekseev <aleksander@timescale.com>
To: Steve Chavez <steve@supabase.io>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2025-03-05T13:46:05Z
Lists: pgsql-hackers
Hi,

> Unlike superuser event triggers, which execute functions for every role, database owner event triggers are only executed for non-superusers.

Even if we forget about the security aspect for a moment, personally I
have mixed feelings about the idea of adding a new type of event
trigger that looks like a regular one but works differently depending
on who creates them. Also what will happen if I promote a user to a
superuser or vice versa? All this doesn't strike me as a great UI.

Maybe you could explain your particular use case?

-- 
Best regards,
Aleksander Alekseev