Re: Key joins

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: 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-05-29 07:45:17
Message-ID: 751d58ec-e8d9-41c8-a8e4-d2133b89a970@app.fastmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

v4 is a small follow-up to fix a non-cassert build failure,
reported by cfbot on NetBSD/FreeBSD animals:

* 0002 removes assertion-only local variables in parse_key_join.c
that triggered -Werror=unused-but-set-variable.

* 0001 and 0003 are unchanged from v3.

/Joel

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2026-05-29 08:09:44 Re: Fix race in ReplicationSlotRelease for ephemeral slots
Previous Message Japin Li 2026-05-29 07:38:32 Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement