Add test for temporal referential integrity
authorÁlvaro Herrera <alvherre@kurilemu.de>
Thu, 11 Sep 2025 16:13:09 +0000 (18:13 +0200)
committerÁlvaro Herrera <alvherre@kurilemu.de>
Thu, 11 Sep 2025 16:16:25 +0000 (18:16 +0200)
commite8cec3d1791c140398454aa561cf51659dd8243d
treec8f364fb12b7fc8db111186b1bc076d6646fdb8e
parenta2b4102a21ad730ce46b059acf49d72151e979f6
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 <pj@illuminatedcomputing.com>
Reviewed-by: Rustam ALLAKOV <rustamallakov@gmail.com>
Reviewed-by: Dean Rasheed <dean.a.rasheed@gmail.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Discussion: https://postgr.es/m/CA+renyUp=xja80rBaB6NpY3RRdi750y046x28bo_xg29zKY72Q@mail.gmail.com
src/test/isolation/expected/fk-snapshot-3.out [new file with mode: 0644]
src/test/isolation/isolation_schedule
src/test/isolation/specs/fk-snapshot-3.spec [new file with mode: 0644]