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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
