Re: alter table cascade does not give notice about dropped indexes

Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> Looks  like alter table does not tells about the indexes it dropped

This is intentional --- we don't require you to say CASCADE to get rid
of an index, either.  I don't recall the exact reasoning anymore, but
if you consult the mailing list archives (probably from the 7.3 beta
period) you can find the discussions that led up to doing it that way.

            regards, tom lane