Subject Re: Inserting into child table with foreign key constraint
Author jeff_j_dunlap
Hi Svein,

Thank you very much for responding to my question. I initially thought
that it must have been some kind of foreign key contraint limitation.

My problem was due to me using a domain for my PRIMARYKEY field which
assigns a default value of 0 (zero)! The trigger checks for a NULL and
sees a zero!

That was what prevented my before insert trigger from working.

Thanks again,

Jeff