[Supabase.com ONLY] Duplicate key value violates unique constraint updating non-unique column

[tecoad]

Bug report

• [X] I confirm this is a bug with Supabase, not with my own application.
• [x] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

On supabase.com, if you have a table in which two columns has the same foreign key, one is unique and other isn't, when updating the one without unique relation in the LIST VIEW, it throws "Failed to update table row: duplicate key value violates unique constraint "recipients_user_id_key".

Doesn't work in localhost, or when updating the record from the drawer.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Go to your Supabase.com project
2. Create two columns with the same foreign key.
3. Set one column as is unique
4. Try to update the value of column without the 'is unique' relation, in the list view. (not in the drawer).
5. I should throw the error "Failed to update table row: duplicate key value violates unique constraint".

Expected behavior

Update without any problem.

System information

• Bug only in supabase.com, in localhost it doesnt happen.

[Hallidayo]

Hi @tecoad - Just checking in here, is this still an issue?

[Hallidayo]

Hi all, We’re going to close this one due to inactivity. Please feel free to reopen if you’re still having issues here or open a new issue.