Re: SQL:2011 Application Time Update & Delete

Paul A Jungwirth <pj@illuminatedcomputing.com>

View thread

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

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter@eisentraut.org>

Date: 2025-10-04T19:48:52Z

Lists: pgsql-hackers

Attachments

v55-0004-Document-temporal-update-delete.patch (text/x-patch) patch v55-0004
v55-0002-Document-temporal-foreign-keys.patch (text/x-patch) patch v55-0002
v55-0001-Add-docs-chapter-for-temporal-tables.patch (text/x-patch) patch v55-0001
v55-0003-Document-temporal-PERIODs.patch (text/x-patch) patch v55-0003
v55-0005-Add-range_minus_multi-and-multirange_minus_multi.patch (text/x-patch) patch v55-0005
v55-0007-Add-tg_temporal-to-TriggerData.patch (text/x-patch) patch v55-0007
v55-0006-Add-UPDATE-DELETE-FOR-PORTION-OF.patch (text/x-patch) patch v55-0006
v55-0009-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch (text/x-patch) patch v55-0009
v55-0008-Look-up-more-temporal-foreign-key-helper-procs.patch (text/x-patch) patch v55-0008
v55-0010-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch (text/x-patch) patch v55-0010
v55-0011-Add-PERIODs.patch (text/x-patch) patch v55-0011

On Wed, Sep 24, 2025 at 9:05 PM Paul A Jungwirth
<pj@illuminatedcomputing.com> wrote:
>
> Here is another update, now with working PERIOD DDL. I also fixed some
> new post-rebase problems causing CI to fail.

More rebase & CI fixes attached.

Rebased to 03d40e4b52 now.

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