SQL:2011 Application Time Update & Delete

Edit
ID 5836
Title SQL:2011 Application Time Update & Delete
CI (CFBot) Summary
Stats (from CFBot) Patch version: v67, Patch count: 7, First patch: +26−0, All patches: +15680−169
Tags SQL Commands
Created 2025-06-22 23:25:42
Last modified 2026-03-01 18:21:23 (18 hours ago)
Latest email 2026-02-20 17:16:11 (1 week ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version 19
Authors Paul Jungwirth (pjungwir)
Reviewers Peter Eisentraut (petere)Become reviewer
Committer Peter Eisentraut (petere)
Links Wiki Git
Emails
SQL:2011 Application Time Update & Delete
First at 2025-06-02 05:24:44 by Paul Jungwirth <pj at illuminatedcomputing.com>
Latest at 2026-02-20 17:16:11 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest attachment (v67-0005-Look-up-additional-temporal-foreign-key-helper-p.patch) at 2026-02-20 17:16:11 from Paul A Jungwirth <pj at illuminatedcomputing.com>
    Attachment (v67-0005-Look-up-additional-temporal-foreign-key-helper-p.patch) at 2026-02-20 17:16:11 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v66-0001-Add-range_get_constructor2-to-lsyscache.patch) at 2026-02-13 20:00:52 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v65-0005-Look-up-additional-temporal-foreign-key-helper-p.patch) at 2026-02-11 21:25:21 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v2-0001-Record-range-constructor-functions-in-pg_range.patch) at 2026-01-19 13:37:43 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (0001-Record-range-constructor-functions-in-pg_range.patch) at 2026-01-08 16:03:02 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v64-0003-Add-isolation-tests-for-UPDATE-DELETE-FOR-PORTIO.patch) at 2025-12-18 22:41:16 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v63-0001-Add-range_get_constructor2.patch) at 2025-12-06 00:42:05 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v62-0002-Add-UPDATE-DELETE-FOR-PORTION-OF.patch) at 2025-11-26 19:29:30 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v61-0003-Add-range_minus_multi-and-multirange_minus_multi.patch) at 2025-11-19 18:49:59 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v60-0001-Fix-typo-in-documentation-about-application-time.patch) at 2025-11-13 04:07:49 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-Fixed-a-typo-left-by-e4d8a2a.patch) at 2025-11-13 03:56:22 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v59-0003-Document-temporal-update-delete.patch) at 2025-11-04 19:12:46 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v58-0002-Document-temporal-foreign-keys.patch) at 2025-10-30 06:02:02 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v57-0002-Document-temporal-foreign-keys.patch) at 2025-10-24 17:08:26 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v56-0003-Document-temporal-PERIODs.patch) at 2025-10-13 06:43:20 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v55-0004-Document-temporal-update-delete.patch) at 2025-10-04 19:48:52 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v54-0003-Document-temporal-PERIODs.patch) at 2025-09-25 04:05:41 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v53-0001-Add-docs-chapter-for-temporal-tables.patch) at 2025-08-29 13:03:44 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v52-0004-Document-temporal-update-delete.patch) at 2025-06-22 23:19:20 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (how-do-triggers-work.sql) at 2025-06-02 05:24:44 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: No)
History
When Who What
2026-03-01 18:21:23 Peter Eisentraut (petere) Added petere as committer
2026-02-13 20:33:34 CFbot Patch does not need rebase anymore
2026-02-13 18:40:31 CFbot Patch needs rebase
2026-02-12 17:58:57 Paul Jungwirth (pjungwir) New status: Needs review
2026-02-11 10:00:45 Peter Eisentraut (petere) New status: Waiting on Author
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2025-12-18 23:01:31 CFbot Patch does not need rebase anymore
2025-12-15 00:13:24 CFbot Patch needs rebase
2025-12-13 16:01:57 Peter Eisentraut (petere) Moved from CF PG19-3 to CF PG19-4
2025-12-13 16:01:51 Peter Eisentraut (petere) New status: Needs review
2025-11-27 15:45:43 Peter Eisentraut (petere) New status: Waiting on Author
2025-11-27 14:08:36 CFbot Patch does not need rebase anymore
2025-11-26 04:17:35 CFbot Patch needs rebase
2025-11-13 17:37:53 Paul Jungwirth (pjungwir) New status: Needs review
2025-11-13 04:01:32 CFbot Patch does not need rebase anymore
2025-11-12 07:43:01 Peter Eisentraut (petere) New status: Waiting on Author
2025-11-07 13:43:31 CFbot Patch needs rebase
2025-11-05 08:36:40 CFbot Patch does not need rebase anymore
2025-11-04 09:15:27 CFbot Patch needs rebase
2025-11-02 08:36:32 CFbot Patch does not need rebase anymore
2025-10-31 09:31:33 CFbot Patch needs rebase
2025-10-04 23:49:36 CFbot Patch does not need rebase anymore
2025-10-04 23:21:55 Paul Jungwirth (pjungwir) Moved from CF PG19-2 to CF PG19-3
2025-10-03 08:21:29 CFbot Patch needs rebase
2025-09-16 23:28:46 CFbot Patch does not need rebase anymore
2025-09-13 16:27:24 CFbot Patch needs rebase
2025-08-31 16:37:33 Peter Eisentraut (petere) Added petere as reviewer
2025-08-29 13:35:34 CFbot Patch does not need rebase anymore
2025-08-11 20:19:02 Paul Jungwirth (pjungwir) Moved from CF PG19-1 to CF PG19-2
2025-08-06 17:07:29 CFbot Patch needs rebase
2025-06-22 23:29:39 Paul Jungwirth (pjungwir) Changed gitlink to https://github.com/pjungwir/postgresql/tree/valid-time
2025-06-22 23:25:42 Paul Jungwirth (pjungwir) Attached mail thread ec498c3d-5f2b-48ec-b989-5561c8aa2024@illuminatedcomputing.com
2025-06-22 23:25:42 Paul Jungwirth (pjungwir) Created patch record
Edit