On Wed, 2002-08-14 at 00:10, Rod Taylor wrote: > > > that TODO item was written before we had dependencies, and I think > > > it's obsolete. Basically the point of the TODO was to avoid > > > having broken views --- and we have solved that problem. > > > > We may have broken views again when "alter table drop column" gets done > > Any view depending on a column which is dropped should also be removed > via the dependency code. Views won't break but you can't drop a column > that is used in a view without specifying cascade. > > This is a case where create or replace view is useful. Change the view > definition to no longer be dependent on the object you wish to drop.
in case of a 'SELECT *' view it could just be an (automatic) recompile. the same in case column type gets changed. --------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
