Rajesh Kumar Mallah wrote: > Tom Lane wrote: > > >Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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 ?
I think so. We consider the index to be bound to the table, while the view is more distinct and could include other table references as well. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
