Hi,

> it is possible to set a trigger on a view.
> So it could be possible to make a changable view with a trigger.
> But in the class org.h2.table.TableView an exception in the methods
> addRow and removeRow is thrown.
>
> It should be possible to make the throwing von exceptions in this
> methods configurable.
>
> What do you think of my idea?

Sure! That's a great idea! Other databases support INSTEAD OF
triggers. I guess that would be the right way to implement it - and
could be used for regular tables as well (and maybe metadata tables).
I didn't think about using for views so far...

"Instead of triggers" are already on the roadmap, I will increase the
priority of that. For me it is currently not the top priority, but if
you are interested, you could implement it yourself of course and send
a patch. I guess it's not very complicated to implement it.

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
-~----------~----~----~----~------~----~------~--~---

Reply via email to