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

Supabase

Hello, I added a unique constraint to a column via the SQL editor but I don't know how to delete it. any help?

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

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**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.

https://stackoverflow.com/questions/51520005/how-to-drop-a-unique-constraint-on-a-column-in-postgres

when i try to find the unique constraint with the query, it doesnt appear. but still get an error

'duplicate key value violates unique constraint "name"'

try this from same link:  select * from information_schema.table_constraints;

i scrolled all the constraint and didnt find any unique on the table

if you used double quotes that won't work.  Has to be single.
select * from information_schema.table_constraints where table_name = 'realtest'

Is the problem maybe a primary key instead of a unique key?

cannot drop constraint rikishis_pkey on table rikishis because other objects depend on it

oh no the primary key is not the column with problems

Thread was archived by <@228048232469495808>. Anyone can send a message to unarchive it.