In non-temporal tables, changes to the primary key of a Parent table and record deletions can be
cascaded to a related Child table using "REFERENCES Parent( Parent_code ) ON DELETE CASCADE ON
UPDATE CASCADE,"
However, since temporal UPDATEs and DELETEs do not behave in the same way as they do in
non-temporal tables, is anyone able to successfully use Referential Integrity constraints between
Parent and Child tables? Or are custom triggers the only solution to maintain temporal relations
between Parents and Children? My question deals specifically with the "Current" style of temporal
relations, where only the currently known attributes and attribute histories are stored.
As a second question, would anyone know if temporal referential integrity is targeted for future
inclusion into the SQL standard?
I would be happy to elaborate on what I mean by Temporal Referential-Integrity (RFI) if my
questions are unclear.
Regards,
Richard Broersma Jr.