The quote was from the Sql Grammar - CREATE TRIGGER
http://www.h2database.com/html/grammar.html#create_trigger
- rami
On 9.6.2010 23:45, David Cuthbert wrote:
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.
