You may be able to remove the unique CONSTRAINT, and not the INDEX itself.
Check your CONSTRAINTS via select * from information_schema.table_constraints;
Then if you find one, you should be able to drop it like:
ALTER TABLE <my_table> DROP CONSTRAINT <constraint_name>
Edit: a related issue is described in this question