Re: Foreign key isolation tests

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
Cc: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Rustam ALLAKOV <rustamallakov(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Foreign key isolation tests
Date: 2025-08-11 15:03:29
Message-ID: CA+Tgmoaqt3vPRH5ZyGov5ZJeL+Kpy7pf6mtsz-QvthPuu91yPw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 18, 2025 at 7:26 PM Paul A Jungwirth
<pj(at)illuminatedcomputing(dot)com> wrote:
> Thanks for taking a look! Here are new patches with those extra tests.
> There are extensive regress tests already, so I just tested the same
> concurrency pattern. I think the results are okay. I do get a
> can't-serialize exception for a couple valid changes under REPEATABLE
> READ and SERIALIZE, but I think they are expected and not a bug. (I
> think you would see the same thing outside of FKs.)

0001 and 0003 look OK to me on a quick read-through. 0002 seems to do
something horrible to isolation_schedule.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-08-11 15:12:17 Re: `pg_ctl init` crashes when run concurrently; semget(2) suspected
Previous Message Nikita Malakhov 2025-08-11 14:49:36 Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)