Supabase: DELETE does not remove the record, although it returns success
After clicking remove the item remains in the database, and the delete() request does not report an exception. DELETE is subject to RLS visibility rights and rules, so no lines may fit the operating conditions.
How to determine the source of the error
Verify the ID sent from the form and whether the user has the right to read and delete the specified record.
Check your existing FOR DELETE policy and whether soft delete is not the right business process.
What to do step by step
1. Enter the deletion rule for the authorized owner or administrator with control on the base side.
2 . For data requiring history, apply archiving and the change log instead of physical DELETE.
How to check the score
The call returns information about the deleted position, the record disappears from the allowed list, and other data remains intact.
What to do
Do not use service role in your browser to circumvent removal policies.