[h2] Re: Voting up for SQL Trigger

Hi, I'd like to throw in my 2 cents about this. Firstly, I think pure SQL triggers would be a terrific (as in 'marvelous' or 'wonderful') addition/improvement to H2. Personally, I think the restriction to Java triggers is severe: Secondly, I think the following features should be supported by

Re: [h2] Re: Voting up for SQL Trigger

Hm... Am I getting something wrong here? Or am I right saying that H2 already supports this via CREATE TRIGGER ... AS sourceCodeString Check http://h2database.com/html/grammar.html#create_trigger Am Dienstag, 17. Januar 2017 21:47:52 UTC+1 schrieb Yan: > > Fair enough Noel. > > What about

[h2] Re: Voting up for SQL Trigger

Hi, One problem is that there is no "standard" SQL mini language. As soon as we support something, people would complain it doesn't support their use case. Regards, Thomas On Thursday, January 19, 2017, Noel Grandin wrote: > No, I meant that I'd be happy to accept a patch that implemented such

Re: [h2] Re: Voting up for SQL Trigger

No, I meant that I'd be happy to accept a patch that implemented such a thing, not that I intended to do it myself On Thu, 19 Jan 2017 at 16:35, Yan wrote: > Thanks Noel - any target release and ETA for it ? > > > On Wednesday, January 18, 2017 at 11:29:38 PM UTC-5, Noel Grandin wrote: > > I'd be

Re: [h2] Re: Voting up for SQL Trigger

Thanks Noel - any target release and ETA for it ? On Wednesday, January 18, 2017 at 11:29:38 PM UTC-5, Noel Grandin wrote: > > I'd be happy with a patch that did that > On Tue, 17 Jan 2017 at 22:47, Yan > > wrote: > >> Fair enough Noel. >> >> What about opening up inline java coding like alias/f

Re: [h2] Re: Voting up for SQL Trigger

I'd be happy with a patch that did that On Tue, 17 Jan 2017 at 22:47, Yan wrote: > Fair enough Noel. > > What about opening up inline java coding like alias/functions ? Currently > triggers must refer to an existing compiled class - the alternative to > provide the java code in the trigger creati

Re: [h2] Re: Voting up for SQL Trigger

Fair enough Noel. What about opening up inline java coding like alias/functions ? Currently triggers must refer to an existing compiled class - the alternative to provide the java code in the trigger creation statement would really be a plus. As an alias gets implicitly the connection, a tri

Re: [h2] Re: Voting up for SQL Trigger

we have triggers, we just don't have triggers implemented in some embedded SQL mini-language. http://h2database.com/html/grammar.html#create_trigger I don't think this is likely to happen any time soon, since I consider the current solution adequate, and I don't see the point in creating a half-b

[h2] Re: Voting up for SQL Trigger

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 ) - any chance we could see this anytime soon for H2 too ?