On Sat, Aug 1, 2026 at 8:33 Peter Geoghegan <[email protected]> wrote: > The attached isolation test patch (written by Claude code) shows that > the new RI fast path can get some things wrong when a foreign key uses > a cross-type equality operator. > > The test has two permutations differing only in the primary key's type > -- date against a timestamp FK in the first, timestamp against > timestamp in the second. The interleaving is identical and the > referenced key is present throughout, so both should behave the same > way. The second succeeds (which is correct), while the first fails > with a foreign key violation (which is incorrect). > > The fast path was introduced by b7b27eb41. This is an issue on 19 and > master only.
Thanks Peter for the report. I’m on vacation atm, will take a look when I get back next week. - Amit >
