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-05 07:58:14
Message-ID: CADzfLwXj_9rz3XGSBVzJ=HdWXt6VMp8h2tAC1e_49yDBESUg-A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

> Thanks Mihail. Adding this to my list to get back to when I’m back next
week

This is one more in the same area (also caught by the stress suite).

The fix and test crafted by Claude were validated and adjusted by me
(but not too carefully).

Enjoy your vacation!
Mikhail.

Attachment Content-Type Size
nocfbot-v1-0001-Re-read-the-FK-constraint-after-locking-the-refer.patch application/x-patch 17.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-08-05 08:00:42 Re: Streamify more code paths
Previous Message Ilia Evdokimov 2026-08-05 07:33:14 Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match