The more I think about it, the more I feel that silently dropping indexes (especially without CASCADE specified) is surprising. It seems especially dangerous for compound indexes that the user may have intended to trim prior to dropping the column.