Hi, Thanks! I could reproduce the problem. It's a bug, and fixing it will require a few changes, I'm currently working on it. Currently views are dropped when altering a table and re-created afterwards. But this is wrong, as it will drop all objects that depend on the view (triggers, access rights and so on). Instead of dropping the views, they should just stay, only re-compiled after the change (they may become invalid, which is ok).
Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
