That's what I was guessing, but it's not super cle...
# javascriptx
xavier
07/21/2022, 6:49 PMThat's what I was guessing, but it's not super clear in the doc. How do I do that?
g
garyaustin
07/21/2022, 6:50 PMDoes your table have a primary key?
garyaustin
07/21/2022, 6:51 PMNormally for what you are doing you would use the uuid of the user.
x
xavier
07/21/2022, 6:53 PMSo i need to set the uuid of the user as a primary key, pass it in my upsert value and it should do the trick?
g
garyaustin
07/21/2022, 6:55 PMWhat is your primary key in the table?
garyaustin
07/21/2022, 6:56 PMOh, maybe that is what you meant you need to do... yes
x
xavier
07/21/2022, 6:58 PMHere is my table
xavier
07/21/2022, 6:58 PMThe id is autogenerated
g
garyaustin
07/21/2022, 6:58 PMYou don't really need id.
garyaustin
07/21/2022, 6:59 PMIn fact you would have to provide id in the upsert too if you have it.
garyaustin
07/21/2022, 6:59 PMWhich would be hard unless you keep track of it.
x
xavier
07/21/2022, 7:00 PMYeah, that means that I would need to select first to get the id and then upsert
xavier
07/21/2022, 7:00 PMwhich makes no sense
g
garyaustin
07/21/2022, 7:00 PMuuid alone is a good primary key.... assuming you don't already have duplicates in the table, then you would have to clean them up.
garyaustin
07/21/2022, 7:03 PMIn fact the docs warn about using a surrogate (incrementing) key with upsert I think not just because of the fetch, but by auto increment nature they would never match...
x
xavier
07/21/2022, 7:04 PMYes Gary, now it seems obvious but it's hard to understand it from the doc…
xavier
07/21/2022, 7:04 PMAnyways, thanks! it works now
g
garyaustin
07/21/2022, 7:05 PMHey I just had to go google surrogate key... lol
x
xavier
07/21/2022, 7:06 PMMaybe we can update the doc?
g
garyaustin
07/21/2022, 7:07 PMYeah it would be more clear if it said (like an auto-incrementing key).
x
xavier
07/21/2022, 7:10 PMIs there a github repo I could fork and make a PR?
g
garyaustin
07/21/2022, 7:13 PMIt is a bit of a learning process (at least it was for me doing a few doc updates awhile back). It is supabase/supabase github to generate a doc issue. The doc repo is embedded in that.