The studio rename or even duplicate the FK when it is updated

[nicetomytyuk]

Bug report

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

Describe the bug

After upgrading the self hosted version of supabase to the latest: supabase/studio:20240422-5cf8f30 when an existing foreign key is updated, the FK name is updated with a prefix of schema name, or in some cases it does even duplicate the key.

To Reproduce

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

1. Go to an existing table in supabase studio
2. Create a FK on a column by giving it a custom name and save
3. Edit the existing FK by updating it's cascading logics
4. Et voilà your FK name has been change from custom_fkey to schema_custom_fkey

Expected behavior

The studio must just update the existing FK values without changing it's name or duplicating it.

Screenshots

System information

• OS: Ubuntu 20.04.6
• Browser: Chrome
• Version of supabase-js: 2.39.7
• Version of Node.js: 20.10.0