Re: RI fast path gets cross-type foreign keys wrong

On Sat, Aug 1, 2026 at 8:33 Peter Geoghegan <pg(at)bowt(dot)ie> 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

>