Local Migrations Don't Copy Database Roles
I'm trying to set up local Supabase for testing. I use a tool called PowerSync which requires its own
powersync_role role. I'm trying to copy my schema from my linked cloud database to my local one, but the migration tries to apply rules set for the powersync_role without actually creating the role, so the migration fails. Am I doing something wrong? How do I fix this?