So I tried to solve this with row-level triggers to adjust

relation_tuple

to stay in sync with row updates. This turned out to be a complex nightmare of PL/SQL code that wasn't solvable in a practical timeframe.