Ok, gotcha. I thought the check meant that you had a specific reason for preventing those tables from being updated. I didn't realize it was just a sort of placeholder until you found out what the real problem was. I'll work on that one.
I've got multiple adds working (ALTER TABLE table1 ADD col1 ADD col2 ADD...), I just need to do a bunch of testing and clean up the code. I'll get a patch to you in a couple weeks when I have some more time. One of my project partners noticed on your roadmap you listed: "Add a role DBA (like ADMIN). " What exactly do you mean by this feature? Are you talking about just adding a pre-defined default user that has access to all tables on all databases? Or are you talking about users being able to do something like "CREATE ROLE newRole DBA" which creates a specific type of role? Thanks, -Evan On Jan 26, 5:06 pm, Thomas Mueller <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
