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
One other fact I can add is that this all seems to work as expected in a local dev environment when running
Thanks!
So, my question really is, what's the right way to deal with custom roles in branches and is my assumption correct that
roles.sqlOne other fact I can add is that this all seems to work as expected in a local dev environment when running
supabase db resetThanks!
