foreign key before primary key

[Ravala]

I have table jacket_function with fields:
(object_id - number Primary key generated by trigger,
Jacket_object_id Foreign Key refers to the field object_id of Jacket table also generated by trigger )
I run into the situation when I have to save data in jacket_function first and then jacket table data second. So I have to put some temporary value in Jacket_object_id and update after jacket record will be inserted. What the best way to do it?
thanks.

 

[sem]

You may use DEFERRED constraint instead of using temporary value.

Regards, Dima

http://seminihin.narod.ru

 

[Ravala]

could you give me example using this constraint.
What I have to specify in Jacket_object_id field?
Thanks.