On Jun 9, 2:30 am, Rami Ojares <[email protected]> wrote: > The documentation clearly states that > "'BEFORE' triggers are called after data conversion is made, default > values are set, null and length constraint checks have been made"
Ah, I missed that. Where is this bit? I've been looking in these spots: http://www.h2database.com/html/features.html#triggers http://www.h2database.com/javadoc/org/h2/api/Trigger.html and otherwise browsing the source. > How about defining your table like this > > CREATE TABLE foo( > id NUMBER(38) PRIMARY KEY NOT NULL, > user VARCHAR(8) DEFAULT 'TestUser' NOT NULL > ) Ah, hadn't thought about using a default value here to get around this. Thanks! -- 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.
