when doing an update to a row how does supabase know which r

Question

when doing an update to a row how does supabase know which row to change

garyaustin · Answer

You are doing update which requires a filter like match operator to specify the row upsert does not need a match as you must provide the primary key

assistattow · Answer

when providing the primary key without RLS it says that I am violating unique constraints on the primary key

assistattow · Answer

with RLS it seems to be fine for now but its an odd one

garyaustin · Answer

update and upsert work differently Your example code used update which also needs a match

assistattow · Answer

ahh alright that makes sense

assistattow · Answer

I assume the reason it works with the RLS without using match is because there is only one entry per user in that table so it can t change anything else so there is no issue on duplicate keys

garyaustin · Answer

yes

assistattow · Answer

alright thank you so much