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.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
