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 original CREATE VIEW . The CASCADE clause it's not standard, but its convenience well worth the fail. Regards, Dario El 09/06/10 20:31, Kerry Sainsbury escribió: > 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 will immediately generate an error when attempting > to drop "v1", unless a "CASCADE" clause is included. > > mysql, Oracle (and I think DB2) will not generate an error when > dropping "v1", but attempts to access "v2" will fail until "v1" is > recreated. They do not offer "CASCADE" clauses that operate in the > same way as Postgres and HSQLDB. > > I'm currently implementing the Postgres/HSQLDB behaviour, although > Thomas hasn't approved or denied this yet (I'm guessing he's asleep > right now!). I would've had it finished, except that Dario has just > added this "CREATE OR REPLACE VIEW" requirement -- damn him! > > Shouldn't have too long to wait for a patch from me, but Thomas may > throw it all away if it doesn't fit in with his plans (and that's > totally fine btw -- he's the boss!) > > Cheers > Kerry > > > On Thu, Jun 10, 2010 at 11:14 AM, Dario V. Fassi > <[email protected] <mailto:[email protected]>> wrote: > > 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 preferred > way , > with a big DDL generation convenience. > > http://www.postgresql.org/docs/8.1/static/sql-createview.html > http://www.postgresql.org/docs/8.1/static/sql-dropview.html > http://www.postgresql.org/docs/8.1/static/sql-createview.html > > > However I suggest you have a copy of the view source code stored > > somewhere outside the database > Yes I going to define a table in the database to store the view > source ;-) > > regards, > Dario > > > > > -- > You received this message because you are subscribed to the Google > Groups "H2 Database" group. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > To unsubscribe from this group, send email to > [email protected] > <mailto:h2-database%[email protected]>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > > -- > You received this message because you are subscribed to the Google > Groups "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. -- Saludos, Dario -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
