Re: SQL:2011 Application Time Update & Delete

From: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL:2011 Application Time Update & Delete
Date: 2026-02-11 21:25:21
Message-ID: CA+renyUhuXB2nTVCMREXew9E4DZOnFxQNjME5bcw91+k72Bosg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jan 22, 2026 at 7:21 AM Peter Eisentraut <peter(at)eisentraut(dot)org> wrote:
>
> I have committed the pg_range patch.

Thanks! Here are v65 patches for UPDATE/DELETE FOR PORTION OF. I kept
the get_range_constructor2 helper function as a separate patch, but it
probably doesn't really need to be a separate commit. Maybe it could
even be inlined into its caller.

Yours,

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com

Attachment Content-Type Size
v65-0005-Look-up-additional-temporal-foreign-key-helper-p.patch text/x-patch 6.3 KB
v65-0001-Add-range_get_constructor2-to-lsyscache.patch text/x-patch 2.1 KB
v65-0002-Add-UPDATE-DELETE-FOR-PORTION-OF.patch text/x-patch 282.7 KB
v65-0003-Add-isolation-tests-for-UPDATE-DELETE-FOR-PORTIO.patch text/x-patch 198.7 KB
v65-0004-Add-tg_temporal-to-TriggerData.patch text/x-patch 9.7 KB
v65-0007-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch text/x-patch 15.5 KB
v65-0006-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch text/x-patch 205.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2026-02-11 22:39:43 Re: Speed up COPY FROM text/CSV parsing using SIMD
Previous Message Tom Lane 2026-02-11 21:10:26 Re: plpgsql: variables of domain of composite types are not correctly initialized