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

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: RI fast path gets cross-type foreign keys wrong
Date: 2026-08-01 22:57:00
Message-ID: CADzfLwUJiVuv69uwuF5z4TrMhNkVwQUXW03q+uVNwmYFLtjEhw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, everyone!

I've (or AI?) found another fast-path/foreign-key - related problem which the
stress-test framework I am prototyping detected. I think this's okay
to send it to that thread; if not, please tell me, and I'll create
another one.

It was all built by Claude; sorry, I have no cycles to carefully
validate all details (there are many findings like this), but it looks
valid - it reproduces the error and even data corruption with just two
new injection points.
I think Amit will be able to understand it all clearly and easily as
the author. If not for some reason, please tell me, and I'll handle it
myself later.

That's a strange time to live :)

Best regards,
Mikhail.

Attachment Content-Type Size
v1-0001-Reproducer-RI-fast-path-opens-an-index-a-concurre.patch application/x-patch 9.2 KB
v1-0003-Re-read-conindid-under-the-referenced-table-s-loc.patch application/x-patch 3.5 KB
v1-0002-Reproducer-RI-fast-path-accepts-a-row-whose-refer.patch application/x-patch 10.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Brazeal 2026-08-01 23:59:18 SERIALIZABLE can commit write skew after SSI summarization
Previous Message Scott Ray 2026-08-01 22:22:54 Re: Recovery conflict resolution misses backends that import snapshots