Postgres: Dropping a column with index drops the index on all other columns
dba.stackexchange.com
dba.stackexchange.com
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!
I'm not arguing this would be correct behavior. It would probably be too magical. But it does make some sense why someone might expect this behavior.