Hi, > AlterTableAlterColumn class and found that when you try to add a > column, it calls the "checkNoViews()" function, which very simply > looks for any existing views and refuses to continue if views already > exist. So, before I can keep going, I need to find out why exactly > tables with views defined can't have new columns added to them. What > is the reason this check exists at all?
I don't know, but maybe it is related to the following problems: table A: column AA; table B: column BB SELECT 1 FROM A, B WHERE AA=BB This becomes invalid if you add the column AA to B or BB to A. Another problem could be: SELECT * FROM A changes if you add a column (not sure if that's a problem itself). I don't know if this is supported (and how) by other databases. I suggest to test it with PostgreSQL and Apache Derby. 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 [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 -~----------~----~----~----~------~----~------~--~---
