Out of the blue i'm getting this error, whllst it'...
# helpj
Jaeden
10/06/2021, 3:57 PMOut of the blue i'm getting this error, whllst it's working fine before. Any idea how I should fix this? I'm using autogenerated uuid v4 for my primary key
Copy code
code: "23505"
details: null
hint: null
message: "duplicate key value violates unique constraint \"watchlists_pkey\""s
silentworks
10/06/2021, 4:07 PMThis would seem as if your uuid field isn't generating a unique uuid each time,
silentworks
10/06/2021, 4:07 PMDid you create the table using the supabase dashboard or using SQL?
j
Jaeden
10/06/2021, 4:12 PMThe dashboard. And used the function inside the default field
Jaeden
10/06/2021, 4:12 PMI’ll double check! In a couple mind and relay here.
Jaeden
10/06/2021, 4:37 PM@User just double checked in case I had a typo or anything but it's there
s
silentworks
10/06/2021, 4:41 PMYeah that looks correct
silentworks
10/06/2021, 4:42 PMWhen do you get the error you are getting? what does the supabase-js code look like?
j
Jaeden
10/06/2021, 5:03 PM Copy code
const addProjectToWatchlist = async (userId, watchlistId, collectedArray) => {
return await supabase
.from('watchlists')
.upsert({ id: watchlistId, author_id: userId, collected: collectedArray })
}Jaeden
10/06/2021, 5:03 PMauthor_idJaeden
10/06/2021, 5:04 PMcollectedJaeden
10/06/2021, 5:05 PMso
idwatchlistsupdateJaeden
10/06/2021, 5:06 PM@User sorry, overall fairly new programmer and new to SQL.
I guess I could use : https://supabase.io/docs/reference/javascript/upsert#upserting-into-tables-with-constraints here?
Jaeden
10/06/2021, 5:08 PMSo that it becomes:
Copy code
const addProjectToWatchlist = async (userId, watchlistId, collectedArray) => {
return await supabase
.from('watchlists')
.upsert({ id: watchlistId, author_id: userId, collected: collectedArray }, { onConflict: id })
}Jaeden
10/06/2021, 5:23 PMSolved ✅ . Thanks for your help silentworks