Re: SQL:2011 Application Time Update & Delete

Paul A Jungwirth <pj@illuminatedcomputing.com>

View thread

From: Paul A Jungwirth <pj@illuminatedcomputing.com>

To: Peter Eisentraut <peter@eisentraut.org>

Cc: Chao Li <li.evan.chao@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-02-13T20:00:52Z

Lists: pgsql-hackers

Attachments

v66-0001-Add-range_get_constructor2-to-lsyscache.patch (text/x-patch) patch v66-0001
v66-0004-Add-tg_temporal-to-TriggerData.patch (text/x-patch) patch v66-0004
v66-0003-Add-isolation-tests-for-UPDATE-DELETE-FOR-PORTIO.patch (text/x-patch) patch v66-0003
v66-0002-Add-UPDATE-DELETE-FOR-PORTION-OF.patch (text/x-patch) patch v66-0002
v66-0005-Look-up-additional-temporal-foreign-key-helper-p.patch (text/x-patch) patch v66-0005
v66-0007-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch (text/x-patch) patch v66-0007
v66-0006-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch (text/x-patch) patch v66-0006

On Wed, Feb 11, 2026 at 1:25 PM Paul A Jungwirth
<pj@illuminatedcomputing.com> wrote:
>
> On Thu, Jan 22, 2026 at 7:21 AM Peter Eisentraut <peter@eisentraut.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.

Here is another round to fix a few rebase conflicts.

Yours,

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Make ExecForPortionOfLeftovers() obey SRF protocol.
- 207cb2abcba0 19 (unreleased) landed
Add isolation tests for UPDATE/DELETE FOR PORTION OF
- b6ccd30d8ff6 19 (unreleased) landed
Add UPDATE/DELETE FOR PORTION OF
- 8e72d914c528 19 (unreleased) landed
Record range constructor functions in pg_range
- c257ba839718 19 (unreleased) landed
Add range_minus_multi and multirange_minus_multi functions
- 5eed8ce50ce9 19 (unreleased) landed
doc: Add section for temporal tables
- e4d8a2af07f5 19 (unreleased) landed
Add assertion check for WAL receiver state during stream-archive transition
- 65f4976189b6 19 (unreleased) cited