| 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 08:54:20 |
| Message-ID: | 2570884f-a018-47c5-a545-dd551d10e5c8@app.fastmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| v5-0003-Add-information_schema.view_constraint_usage.patch.gz | application/x-gzip | 2.9 KB |
| v5-0002-Implement-FOR-KEY-join-support.patch.gz | application/x-gzip | 175.0 KB |
| v5-0001-Serialize-routine-definition-changes-with-depende.patch.gz | application/x-gzip | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2026-05-29 08:56:51 | Re: generic plans and "initial" pruning |
| Previous Message | Chao Li | 2026-05-29 08:40:56 | Fix regression in vacuumdb --analyze-in-stages for partitioned tables |