Alembic drops indexes for foreign keys

Question

I have a column address_id = db.Column(db.Integer, db.ForeignKey(Address.id, ondelete='CASCADE'), index=True). Autogenerating a migration with Alembic always adds a drop_index operation.

op.drop_index('address_id', 'companies')

Why does this happen every time I generate a migration?

score 4 · Accepted Answer · edited Dec 31 '13 at 19:45

4

This is a known bug in Alembic 0.6.1. Upgrade to 0.6.2 or newer and the problem will go away.

edited Dec 31 '13 at 19:45

davidism

121,510
29
395
339

answered Dec 31 '13 at 19:12

Miguel Grinberg

65,299
14
133
152

Alembic drops indexes for foreign keys

1 Answers1