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