Re: Key joins

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: "Arne Roland" <arne(dot)roland(at)malkut(dot)net>, "Anders Granlund" <anders(dot)granlund(dot)0(at)gmail(dot)com>, "Andreas Karlsson" <andreas(at)proxel(dot)se>, "Vik Fearing" <vik(at)chouppes(dot)com>
Subject: Re: Key joins
Date: 2026-06-04 16:02:27
Message-ID: a8acdff4-1231-49b1-8866-c65d7897ff5a@app.fastmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
v9-0003-Add-information_schema.view_constraint_usage.patch.gz application/x-gzip 2.9 KB
v9-0002-Implement-FOR-KEY-join-support.patch.gz application/x-gzip 178.6 KB
v9-0001-Serialize-routine-definition-changes-with-depende.patch.gz application/x-gzip 1.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-06-04 16:25:52 Re: Use ereport() instead of elog() for invalid weights in setweight()
Previous Message Jacob Champion 2026-06-04 16:02:13 Re: Heads Up: cirrus-ci is shutting down June 1st