Got fields a,b, both in primary key.
will not work --> column b can not be null.Code:insert into t (a) values ('foo')
Have trigger on table t, before insert, which assigns value to b
same thing will not work --> column b can not be null.
Trigger on before insert is not even triggered, tested.
I guess what I would expect is, having trigger as described, insert should work ?
EDIT: (in short)
It works like this:
2. check for various things like 'can not be null'
3. Before insert trigger is triggered
What I would expect:
2. Before insert trigger is triggered
3. check for various things like 'can not be null'