Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table cascade does not give notice about dropped indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: alter table cascade does not give notice about dropped indexes
Date
Msg-id 20935.1088867772@sss.pgh.pa.us
Whole thread Raw
In response to alter table cascade does not give notice about dropped indexes  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: alter table cascade does not give notice about dropped  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Problems restarting after database crashed (signal 11).
Next
From: Dennis Gearon
Date:
Subject: connection parameters