Help with handling soft-deletes where update is being blocked by read-access RLS Policy
Hi all!
I have an "is_archived" column in a table and have set an RLS read-access policy to only show is_archived = false. However, when I call my patch (.update) to switch the boolean is_archived to TRUE, I am getting blocked by my read-access RLS policy. I do not have any .select on my async call so I am completely confused as to how/why this is happening. I have also set { returning: "minimal" }. .update says it does not return anything by default, so completely lost.
Soft deletes are so common, is there a better way to be handling this if what I am running into is common?
Thanks!
I have an "is_archived" column in a table and have set an RLS read-access policy to only show is_archived = false. However, when I call my patch (.update) to switch the boolean is_archived to TRUE, I am getting blocked by my read-access RLS policy. I do not have any .select on my async call so I am completely confused as to how/why this is happening. I have also set { returning: "minimal" }. .update says it does not return anything by default, so completely lost.
Soft deletes are so common, is there a better way to be handling this if what I am running into is common?
Thanks!
