Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Am I reading the documentation wrong? UPSERT isn't that update if exists or insert new?

Hello <@443116621054345226>!
This thread has been automatically created from your message in <#843999948717555735> a ``few seconds ago``.

Pinging <@&951828363943759883> so that they see this as well!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ... menu) and select **Leave Thread** to unsubscribe from future updates.

**Want to change the title?**
Use the `/title` command!

**We have solved your problem?**
Click the button below to archive it.

const { data, error } = await supabase
  .from('users')
  .upsert({ username: 'supabot' }, { onConflict: 'username' })

^always gives the error "{message: "there is no unique or exclusion constraint matching the ON CONFLICT specification", code: "42P10", details: null, hint: null}"

no matter if "users" has a row where username === 'supabot'

Upsert is basically insert, but update on conflicts https://wiki.postgresql.org/wiki/UPSERT

is your username column definied as UNIQUE?

Sorry, it DOES work - the fault was hanging cloudflare workers preview