Request a Demo
Home   >   mailing lists

Re: Foreign key isolation tests - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Foreign key isolation tests
Date
Msg-id CA+Tgmoaqt3vPRH5ZyGov5ZJeL+Kpy7pf6mtsz-QvthPuu91yPw@mail.gmail.com
Whole thread Raw
In response to Re: Foreign key isolation tests  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: Foreign key isolation tests
List pgsql-hackers
Tree view 
On Fri, Jul 18, 2025 at 7:26 PM Paul A Jungwirth
<pj@illuminatedcomputing.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

pgsql-hackers by date:

Previous
From: Nikita Malakhov
Date:
Subject: Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)
Next
From: Tom Lane
Date:
Subject: Re: `pg_ctl init` crashes when run concurrently; semget(2) suspected