PostgreSQL Drop Unique Index

Question

I have this statement in Postgres to create a unique index: CREATE UNIQUE INDEX CONCURRENTLY organization_user_ux1 ON organization_user (organization_id,user_id);

... I need to drop this unique index, so I tried:

ALTER TABLE public.organization_user DROP INDEX organization_user_ux1;

and recieved error: ERROR: syntax error at or near "organization_user_ux1" using flyway to execute these scripts.

How do I correctly undo this concurrent unique index?

Akhilesh Mishra · Accepted Answer · 2020-06-11 19:59:31Z

1

Read This documentation for your reference Drop Index

IN your case :

DROP INDEX organization_user_ux1

or if you want it concurrently

DROP INDEX CONCURRENTLY organization_user_ux1

answered Jun 11, 2020 at 19:59

Akhilesh Mishra

6,1503 gold badges20 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jjanes Over a year ago

@MaxMilovets All supported versions of PostgreSQL support drop index concurrently. If you are using a version so ancient that it does not, you should 1) upgrade urgently, 2) tell us the version, 3) not use features unsupported on the ancient version.

Collectives™ on Stack Overflow

PostgreSQL Drop Unique Index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related