Re: Possible enhancement : replace view ?

On Wed, 2002-08-14 at 04:23, Emmanuel Charpentier wrote:
> Hannu Krosing wrote:
> > 
> > I'm trying to propose a scenario where
> > 
> > 1. The SELECT clause defining the view is preserved
> > 
> > 2. DROP of undrlying table/column will _not_ drop the view, but just
> > mark it dirty
> > 
> > 3. Using the view checks for the dirty flag and if it is set tries to
> > recreate the view from its plaintext definition.
> 
> I might be dense, but why not try to recreate it directly after the 
> table/column modification ?

If it is a DROP TABLE/CREATE TABLE sequence you have no idea that you
have to recreate a view.

-----------
Hannu