supabase-postgres.git / summary / log / commit / refs
commit 1bf753cefd02d60a5754c8cacd7461bbd781fdcd
Author: Bobbie Soedirgo <bobbie@soedirgo.dev>
Commit: Steve Chavez <stevechavezast@gmail.com>
Date: Wed Apr 02 07:25:44 2025 +0000
feat(migrations): alter internal evt trig owner
.../20231020085357_revoke_writes_on_cron_job_from_postgres.sql | 1 +
...7_alter_internal_event_triggers_owner_to_supabase_admin.sql | 10 ++++++++++
nix/tests/expected/evtrigs.out | 4 ++--
3 files changed, 13 insertions(+), 2 deletions(-)
diff --git a/migrations/db/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql b/migrations/db/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql
index 25b82711..4aea5d10 100644
--- a/migrations/db/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql
+++ b/migrations/db/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql
@@ -40,6 +40,7 @@ END;
$$;
drop event trigger if exists issue_pg_cron_access;
+alter function extensions.grant_pg_cron_access owner to supabase_admin;
CREATE EVENT TRIGGER issue_pg_cron_access ON ddl_command_end
WHEN TAG IN ('CREATE EXTENSION')
EXECUTE FUNCTION extensions.grant_pg_cron_access();
diff --git a/migrations/db/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql b/migrations/db/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql
new file mode 100644
index 00000000..9308f07d
--- /dev/null
+++ b/migrations/db/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql
@@ -0,0 +1,10 @@
+-- migrate:up
+drop event trigger if exists issue_pg_net_access;
+
+alter function extensions.grant_pg_net_access owner to supabase_admin;
+
+CREATE EVENT TRIGGER issue_pg_net_access ON ddl_command_end
+ WHEN TAG IN ('CREATE EXTENSION')
+ EXECUTE FUNCTION extensions.grant_pg_net_access();
+
+-- migrate:down
diff --git a/nix/tests/expected/evtrigs.out b/nix/tests/expected/evtrigs.out
index 7f802583..3e3f523f 100644
--- a/nix/tests/expected/evtrigs.out
+++ b/nix/tests/expected/evtrigs.out
@@ -12,14 +12,14 @@ join pg_namespace n_func
where p.prorettype = 'event_trigger'::regtype;
evtname | evtowner | evtfunction_schema | evtfunction | function_owner
----------------------------------------+----------------+--------------------+------------------------------------+----------------
- issue_pg_net_access | postgres | extensions | grant_pg_net_access | postgres
issue_pg_graphql_access | supabase_admin | extensions | grant_pg_graphql_access | supabase_admin
issue_graphql_placeholder | supabase_admin | extensions | set_graphql_placeholder | supabase_admin
pgrst_ddl_watch | supabase_admin | extensions | pgrst_ddl_watch | supabase_admin
pgrst_drop_watch | supabase_admin | extensions | pgrst_drop_watch | supabase_admin
graphql_watch_ddl | supabase_admin | graphql | graphql.increment_schema_version | supabase_admin
graphql_watch_drop | supabase_admin | graphql | graphql.increment_schema_version | supabase_admin
- issue_pg_cron_access | supabase_admin | extensions | grant_pg_cron_access | postgres
+ issue_pg_cron_access | supabase_admin | extensions | grant_pg_cron_access | supabase_admin
+ issue_pg_net_access | supabase_admin | extensions | grant_pg_net_access | supabase_admin
pg_tle_event_trigger_for_drop_function | supabase_admin | pgtle | pgtle.pg_tle_feature_info_sql_drop | supabase_admin
pgaudit_ddl_command_end | supabase_admin | public | pgaudit_ddl_command_end | supabase_admin
pgaudit_sql_drop | supabase_admin | public | pgaudit_sql_drop | supabase_admin
[parent: f832c257cb31]