Branch migrations that depend on roles.sql fail.
Hi! Recently my branches started failing to start up because they contain migrations with GRANT statements for a custom role I use. With the recently auth changes I was no longer able to create that role in a migration so I moved it to roles.sql. I thought that worked for a awhile but now the migrations are failing because that role has not yet been created.
So, my question really is, what's the right way to deal with custom roles in branches and is my assumption correct that
roles.sql should be applied prior to the migrations during branch boostrapping?
One other fact I can add is that this all seems to work as expected in a local dev environment when running supabase db reset.
Thanks!0 Replies