0 - 3 of 3 tags for soft ri

Hi All,


I have to implement a soft ri in one of my project.


Following are the tables in PER_DATA:


person_mst with columns

p_num bigint

p_dt date

p_status char(1)


composite key is defined on columns p_num and p_dt

person_mst was created by user xyz.

I've found an appendix at the end of TD 13.10's "Temporal Table Support" reference, which contains some SQL code about how can you validating temporal referential integrity shown below. It works great until I want to embed it to a trigger's ...WHEN ( EXISTS (<here>))... section.

I've read the most relevant references from the TD 13.10 documents, but as I see, only soft RI-s are available with temporality - so you must do it yourself...

Which is the most acceptable (and also the simplest) solution maintaining RI's between temporal tables? TRIGGERs?