Transaction (Rollback & Commit)
Hello all,
I'm creating functions to perform multiple actions (Insert and delete) on tables. I'm afraid that some failure might take place while the function is in process, so is it recommended to use Rollback & commit in such scenario?
I've tried my self and found out that the function is not committing unless all actions took place. But wanted to double check with you all if rollback and commit is necessary or not or supabase is already handling it.
Thanks
I'm creating functions to perform multiple actions (Insert and delete) on tables. I'm afraid that some failure might take place while the function is in process, so is it recommended to use Rollback & commit in such scenario?
I've tried my self and found out that the function is not committing unless all actions took place. But wanted to double check with you all if rollback and commit is necessary or not or supabase is already handling it.
Thanks
