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
Is there any way to explicitly exclude tables in the migration process? Any older version that could work? any idea?
I'm completely stuck
thank you
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'], 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?
I'm completely stuck
thank you
