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