Bulk Update using upsert
I am tryin to bulk-update data using upsert but data are not getting updated and I am not getting any error
6 Replies
You need to meet RLS for select, update and insert.
it is disabled
Then you will need to present some example of what is not working. Upsert works.
Do I need to pass all the columns when doing upsert?
You have to pass the primary key and conflict columns.
Not getting an error seems strange if RLS is disabled.
ok exactly what I am doing. I had to set to allow "NULL" for the columns that I am not passing in the upsert. It didn't work anyway.