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