RLS policy blocking Insert from Debug
Would anyone know why this is happening?
"
Error submitting review: PostgrestException(message: new row violates row-level security policy for table "reviews", code: 42501, details: , hint: null)
"
I'm running it in VSCode debug instance
"
Error submitting review: PostgrestException(message: new row violates row-level security policy for table "reviews", code: 42501, details: , hint: null)
"
- My logged-in Flutter user cannot perform an INSERT on a table with a simple RLS policy FOR INSERT TO authenticated WITH CHECK (true) or WITH CHECK (auth.role() = 'authenticated').
- The action succeeds when RLS is disabled.
- We have verified the anonKey, the table schema, foreign keys, and data types are all correct.
- We have recreated the policies and the table itself using the SQL editor.
I'm running it in VSCode debug instance
