Resurrecting the request again as it is on the roadmap for years and we have no visibility on how high it is on the priority list.
HSQLDB supports SQL triggers since last year (here <http://www.hsqldb.org/doc/guide/triggers-chapt.html>) - any chance we could see this anytime soon for H2 too ? Thanks, Yan On Monday, February 4, 2013 at 6:54:09 PM UTC-5, Thomas Mueller Graf wrote: > > Hi, > > Of course one option would be to provide a patch for H2 :-) > > About compatibility: should H2 support T-SQL (Microsoft), PL/SQL (Oracle), > or another? See also > http://en.wikipedia.org/wiki/SQL#Procedural_extensions - it seems to be > there is even less standardization than for SQL itself. Java user defined > functions (that uses JDBC) on the other hand run with any database (even > thought you might not be able to call it from within SQL). > > Regards, > Thomas > > > > > On Fri, Feb 1, 2013 at 10:23 AM, davide.cavestro <davide....@gmail.com > <javascript:>> wrote: > >> Thomas Mueller-6 wrote >> > Sure, I will increase the priority. >> >> Hi Thomas, >> sorry for resurrecting this old thread, but I also don't want to >> cross-post... so I resolved to write here. >> >> After some years it seems like /Sql triggers/ are still /Priority 2/. >> Hence >> I guess there's no enough demand from other users. >> >> I thought it was implemented, but maybe there's better ways to achieve >> what >> I need. I'd like to recursively propagate changes on a hierarchical >> structure: i.e. I have a tree structure backed by a db table, where every >> row holds an amount representing the sum of the children amounts. Every >> time >> I change an amount on a leaf node (calculated summing amounts from a - >> different - slave table) this change has to be reflected into all the >> ancestor nodes up to the root. >> I know this lead to some data redundancy, but I consider it acceptable in >> order to avoid continuous computing this data inside the application and >> at >> report generation time. >> I feel implementing it with triggers backed by my java code somewhat ties >> the DB too strictly to my code. >> BTW: what's the best way to achieve it in H2? >> >> Cheers >> Davide >> >> >> >> -- >> View this message in context: >> http://h2-database.66688.n3.nabble.com/Voting-up-for-SQL-Trigger-tp470860p4025659.html >> Sent from the H2 Database mailing list archive at Nabble.com. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to h2-database...@googlegroups.com <javascript:>. >> To post to this group, send email to h2-da...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
