Horton

Add test for temporal referential integrity

Álvaro Herrera <alvherre@kurilemu.de>

View on postgr.es
Commit: e8cec3d1791c140398454aa561cf51659dd8243d
Author: Álvaro Herrera <alvherre@kurilemu.de>
Date: 2025-09-11T16:16:25Z
Releases: 19 (unreleased) 
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

Files

PathChange+/−
src/test/isolation/expected/fk-snapshot-3.out added +213 −0
src/test/isolation/isolation_schedule modified +1 −0
src/test/isolation/specs/fk-snapshot-3.spec added +82 −0

Discussion