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-11T21:25:21Z

Lists: pgsql-hackers

Attachments

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

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.

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