Re: alter table cascade does not give notice about dropped

Tom Lane wrote:

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