Re: alter table cascade does not give notice about dropped

Tom Lane wrote:

>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 initailly ran the alter table without cascade option ,

it told me  there is a dependent view.

I did cascade  , it droped the view and it also dropped a
multicolumn  index that contained the column.

I notified me about the dropped view but not about
the index.

Is that ok ?

Regds
Mallah.


>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
>
>
>


--

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users         |
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/                |
+---------------------------------------------------+