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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: alter table cascade does not give notice about dropped indexes
Date: 2004-07-03 15:16:12
Message-ID: 20935.1088867772@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rajesh Kumar Mallah <mallah(at)trade-india(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2004-07-03 15:53:09 connection parameters
Previous Message Greg Stark 2004-07-03 13:48:25 Re: Problems restarting after database crashed (signal 11).