Greetings,
the change with the new patch is, that the locking is less excessive.
Foreign key paths unnecessarily blocked concurrent DML. This version of
the patch relaxes the locking to a more balanced degree. In particular
every plainly reading SELECT now takes only an ACCESS SHARE.
Regards
Arne
On 2026-06-04 6:02 PM, Joel Jacobson wrote:
> On Mon, Jun 1, 2026, at 22:36, Joel Jacobson wrote:
>> Ops, that extra ERROR: line was a mistake, sorry about that.
>>
>> The corresponding subsection has now also been fixed in the web version:
>> https://keyjoin.org/#sec7.4.13
> v9 rebases over Stamp 19beta1 and improves one type of error message in 0002.
>
> The affected queries were already rejected correctly. The change is
> only that DETAIL now first reports if there is not even a matching
> referential constraint.
>
> 0001 and 0003 are unchanged from v8.
>
> /Joel
