My first idea when this was mentioned was more like ALTER TABLE .... CASCADE where CASCADE meant recompile all the views that depend on that table. Not that I think any of this is a good idea, but if it was going to be done, that's what would make the most sense to me. - Ian ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
