Re: Key joins

Joel Jacobson <joel@compiler.org>

From: "Joel Jacobson" <joel@compiler.org>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Cc: "Arne Roland" <arne.roland@malkut.net>, "Anders Granlund" <anders.granlund.0@gmail.com>, "Andreas Karlsson" <andreas@proxel.se>, "Vik Fearing" <vik@chouppes.com>

Date: 2026-05-29T08:54:20Z

Lists: pgsql-hackers

Attachments

v5-0003-Add-information_schema.view_constraint_usage.patch.gz (application/x-gzip)
v5-0002-Implement-FOR-KEY-join-support.patch.gz (application/x-gzip)
v5-0001-Serialize-routine-definition-changes-with-depende.patch.gz (application/x-gzip)

On Fri, May 29, 2026, at 09:45, Joel Jacobson wrote:
> On Fri, May 29, 2026, at 07:08, Joel Jacobson wrote:
>> On Fri, May 29, 2026, at 00:13, Joel Jacobson wrote:
>>> On Thu, May 28, 2026, at 20:47, Joel Jacobson wrote:
>>>> Hi hackers,
>>>>
>>>> This patch implements a new SQL language feature, that we intent to
>>>> submit as a Change Proposal to the WG 3 SQL committee for the next
>>>> meeting in Stockholm in June.  We would greatly appreciate any feedback
>>>> from the community.
>> ...
>>>> The attached Discussion paper has also been published at https://keyjoin.org
>>>> with all examples in the paper runnable in the browser using a patched PGLite.

v5 is another small follow-up to fix a cfbot regression-test warning:

* 0002 renames the roles created by key_join.sql to use the required
  regress_ prefix, so builds with ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS
  do not emit warnings.

* 0001 and 0003 are unchanged from v4.

/Joel