Comment by bugfactory

What else would you have expected? You can't index what's not there. It makes sense that DROP COLUMN would also cascade to DROP INDEXes.

The author of the question writes:

> If you overlook such situation, you can get serious problems in production.

Really? I hope you think it through before you DROP COLUMN in production!