alter table cascade does not give notice about dropped indexes

Hi,

Looks  like alter table does not tells about the indexes it dropped
PG version: 7.4.3

Regds
mallah.



tradein_clients=# \d general.membership_status
                   Table "general.membership_status"
+--------------------+-----------------------+------------------------+
|       Column       |         Type          |       Modifiers        |
+--------------------+-----------------------+------------------------+
| userid             | integer               | not null               |
| profile_id         | integer               | not null               |
| product_id         | integer               | not null               |
| num_inq            | integer               | default 0              |
| listing            | character varying(50) |                        |
| num_leads_featured | integer               | default 0              |
| num_leads_pic      | integer               | default 0              |
| deleted            | boolean               | not null default false |
+--------------------+-----------------------+------------------------+
Indexes:
    "user_profile_product_id" unique, btree (userid, profile_id,
product_id) WHERE (deleted IS FALSE)

tradein_clients=#
tradein_clients=# ALTER TABLE general.membership_status  drop column
profile_id cascade;
NOTICE:  drop cascades to rule _RETURN on view active_membership_status
NOTICE:  drop cascades to view active_membership_status
ALTER TABLE
Time: 992.921 ms
tradein_clients=# \d general.membership_status
                   Table "general.membership_status"
+--------------------+-----------------------+------------------------+
|       Column       |         Type          |       Modifiers        |
+--------------------+-----------------------+------------------------+
| userid             | integer               | not null               |
| product_id         | integer               | not null               |
| num_inq            | integer               | default 0              |
| listing            | character varying(50) |                        |
| num_leads_featured | integer               | default 0              |
| num_leads_pic      | integer               | default 0              |
| deleted            | boolean               | not null default false |
+--------------------+-----------------------+------------------------+

tradein_clients=#