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-03-17T14:29:07Z

Lists: pgsql-hackers

Attachments

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

On Fri, Mar 13, 2026 at 10:06 AM Paul A Jungwirth
<pj@illuminatedcomputing.com> wrote:
>
> On Thu, Mar 12, 2026 at 1:39 AM Peter Eisentraut <peter@eisentraut.org> wrote:
> > Hi Paul,
> >
> > Review of v67-0001-Add-range_get_constructor2-to-lsyscache.patch and
> > v67-0002-Add-UPDATE-DELETE-FOR-PORTION-OF.patch:
>
> Thanks for taking another look! v68 patches attached, details below:

This needed a rebase, so here it is. Now rebased up to c9babbc881.

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