Hi, > But it seems this does not work. All I get is > General error: "java.lang.NullPointerException"
I will make it throw a better exception message. Unfortunately it's not possible to define foreign keys on information_schema tables (also you can't define triggers yet). There is a feature request for triggers on information_schema tables, but it's relatively hard to implement. To delete old data when opening the database, you could do is create a trigger on a dummy table (or on the table above) and delete the old data when the trigger object is created. > shouldn't > a single create table statement be atomic, either fail or succeed? Yes, it should be. > are ON DELETE CASCADE > and ON UPDATE CASCADE > defaults if I don't mention them? No. I will document that. 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.
