SQL:2011 Application Time Update & Delete

Edit
ID 5836
Title SQL:2011 Application Time Update & Delete
CI (CFBot) Summary
Stats (from CFBot) Patch version: v63, Patch count: 8, First patch: +69−0, All patches: +26581−530
Topic SQL Commands
Tags
Created 2025-06-22 23:25:42
Last modified 2025-12-13 16:01:57 (6 hours ago)
Latest email 2025-11-27 15:44:26 (2 weeks ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
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
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 2025-12-06 00:42:05 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest attachment (v63-0001-Add-range_get_constructor2.patch) at 2025-12-06 00:42:05 from Paul A Jungwirth <pj at illuminatedcomputing.com>
    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
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