push don't add supabase policies, and if I use migrate postgresql complains auth.users exists
Hi, I'm stuck with this problem:
I'm developing a muli-tennant webapp so I enabled RLS and defined policies so each tennant can only access to his data. However, it seems drizzle-kit push doesn't apply policies to supabase (I can't see any of them in the admin panel) , searching on github seems this is a bug, so I try to generate and migrate but then I face a postgresql error telling me that users table (from auth) already exists.
So far I tried: moving the authusers table to another ts file (wrong, drizzle checks the dependency), editing the drizzle.config so
schemaFilter: ['public']
schemaFilter: ['public']
, doesn't solve the issue. Downgraded to ^0.30.0 and tried to push, same issue.
Is there any way to explicitly exclude tables in the migration process? Any older version that could work? any idea?