id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27520	sqlmigrate generates a duplicate DROP INDEX statement (migrate works fine)	Jerome Leclanche	nobody	" I just removed `db_index=True` on a CharField I no longer want indexed, on postgresql, Django 1.10. The migration runs fine (it removes both the _like and regular index), but when I run `sqlmigrate` it actually generates *three* ""DROP INDEX"" statements instead of two: one of the two is duplicated.

Results of sqlmigrate:


{{{
BEGIN;
--
-- Alter field real_name on globalgameplayer
--
DROP INDEX ""games_globalgameplayer_real_name_7e583535_like"";
DROP INDEX ""games_globalgameplayer_real_name_7e583535_uniq"";
DROP INDEX ""games_globalgameplayer_real_name_7e583535_like"";
COMMIT;
}}}

Of course, running this doesn't work. Simply running `migrate` however will work fine.

Reference commit: https://github.com/HearthSim/HSReplay.net/commit/cdbae94d0bf397c1c9d6362d847e0ca120f0385b"	Bug	closed	Migrations	1.10	Normal	duplicate			Unreviewed	0	0	0	0	0	0