Subject | Re: Inserting into child table with foreign key constraint |
---|---|
Author | jeff_j_dunlap |
Post date | 2009-02-21T20:56:45Z |
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
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