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 22910 sqldropindexes yields wrong indexes names when using postgresql_psycopg2 anonymous nobody "If you are using a postgres database (with postgresql_psycopg2), and run: {{{ ./manage.py sqldropindexes example_app }}} The DROP INDEX commands printed have the index names wrong, with random strings at the end of them. Example: With these simple models: {{{ class City(models.Model): name = models.CharField(max_length=50) class Human(models.Model): name = models.CharField(max_length=50) city = models.ForeignKey(City) }}} If you run the sqlindexes command (which works ok), it outputs this: {{{ ./manage.py sqlindexes example_app BEGIN; CREATE INDEX ""app_human_city_id"" ON ""app_human"" (""city_id""); COMMIT; }}} But if you run the sqldropindexes command, it outputs this, which has the indexes names broken: {{{ /manage.py sqldropindexes example_app BEGIN; DROP INDEX ""app_human_b376980e"" ; COMMIT; }}} " Bug closed Database layer (models, ORM) 1.6 Normal duplicate sqldropindexes,postgresql Unreviewed 0 0 0 0 0 0