Add test for temporal referential integrity This commit adds an isolation test showing that temporal foreign keys do not permit referential integrity violations under concurrency, like fk-snapshot-2. You can show that the test fails by passing false for detectNewRows to ri_PerformCheck in ri_restrict.
Author: Paul Jungwirth <p...@illuminatedcomputing.com> Reviewed-by: Rustam ALLAKOV <rustamalla...@gmail.com> Reviewed-by: Dean Rasheed <dean.a.rash...@gmail.com> Reviewed-by: Robert Haas <robertmh...@gmail.com> Discussion: https://postgr.es/m/CA+renyUp=xja80rbab6npy3rrdi750y046x28bo_xg29zky...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e8cec3d1791c140398454aa561cf51659dd8243d Modified Files -------------- src/test/isolation/expected/fk-snapshot-3.out | 213 ++++++++++++++++++++++++++ src/test/isolation/isolation_schedule | 1 + src/test/isolation/specs/fk-snapshot-3.spec | 82 ++++++++++ 3 files changed, 296 insertions(+)
