Re: Views that depends on other view

Hi Kerry, and sorry. I'm happy to hear that you have an implementation of this feature and I'm sure Tomas will receive it in good grace. One detail, DB2 invalidate any dependent view of the view that it's invalidated itself (as standards suggest) and you can re-validate repeating the same origina

Re: Views that depends on other view

Hi Folks, I've done some investigation and learned that, given this test case: create table test(a int, b int, c int) insert into test(a, b, c) values (1, 2, 3) create view v1 as select a as b, b as a from test create view v2 as select * from v1 drop view v1 Postgres and HSQLDB

Re: Views that depends on other view

hi, >> Modify a view It's not a use case, it's a routine maintenance task. >> > I will add a feature request for "Drop with invalidate views (so that > source code is not lost). ok, thanks. > Check what other databases do exactly. > The sentence CREATE OR REPLACE VIEW ala PgSql, it's my p

Re: Views that depends on other view

Hi, > Modify a view It's not a use case, it's a routine maintenance task. I will add a feature request for "Drop with invalidate views (so that source code is not lost). Check what other databases do exactly." However I suggest you have a copy of the view source code stored somewhere outside the

Re: Views that depends on other view

Hi, >> Simply modify a view that has others views depends on (use this one). >> > What I mean is: the actual real world use case. Why do you modify a view? > Modify a view It's not a use case, it's a routine maintenance task. I can't agree that a view change (without a cascade drop) can ac

Re: Views that depends on other view

Hi, > > what is your use case? > Simply modify a view that has others views that depend (use) this one. I think I need to explain again what I mean with "use case". What I mean is: the actual real world use case. Why do you modify a view? Regards, Thomas -- You received this message because yo

Re: Views that depends on other view

Hi, > Drop table and drop view will also drop all views that depend on this > table / view. I will document that. However there may be a bug in that > area. I think you want to change a view, right? Could you explain what > is your use case? > Simply modify a view that has others views that depe

Re: Views that depends on other view

Hi, > I wish to know about what's expected to happens when a view that is used > in some others views is recreated. Drop table and drop view will also drop all views that depend on this table / view. I will document that. However there may be a bug in that area. I think you want to change a view,

Re: Views that depends on other view

Hi, > I wish to know about what's expected to happens when a view that is used > in some others views is recreated. > > I suppose that all dependent views become invalid (not dropped) , ok ? > > Then, what's the best way to re-validate invalid views ? > On a database was properly migrated to 1

Re: Views that depends on other view

Very sorry, I missed:|ALTER VIEW viewName RECOMPILE| > To do that other databases support the CREATE or REPLACE VIEW , and > anothers revalidate repeating the original create view. > regards, Dario -- You received this message because y

Views that depends on other view

Hi, I wish to know about what's expected to happens when a view that is used in some others views is recreated. By recreated I mean: SET AUTOCOMMIT OFF; DROP VIEW XX ; CREATE VIEW XX AS ...; COMMIT; I suppose that all dependent views become invalid (not dropped) , ok ? Then, what's the best way