UPDATE/DELETE FOR PORTION OF

Edit
ID 7571
Title UPDATE/DELETE FOR PORTION OF
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 6, First patch: +78−25, All patches: +17147−184
Tags SQL Commands
Created 2026-10-31 20:45:32
Last modified 2026-10-31 22:02:16 (31 minutes ago)
Latest email 2026-10-31 17:31:51 (5 hours ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version 20
Authors Paul Jungwirth (pjungwir)
Reviewers 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 2026-07-21 06:53:29 by Peter Eisentraut <peter at eisentraut.org>
Latest attachment (0008-test-fpo-crash-instead-of-trigger-views.patch) at 2026-04-09 19:42:23 from SATYANARAYANA NARLAPURAM <satyanarlapuram at gmail.com>
    Attachment (0008-test-fpo-crash-instead-of-trigger-views.patch) at 2026-04-09 19:42:23 from SATYANARAYANA NARLAPURAM <satyanarlapuram at gmail.com> (Patch: Yes)
    Attachment (v1-0001-refactoring-transformForPortionOfClause.no-cfbot) at 2026-04-07 04:03:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v70-0004-Add-tg_temporal-to-TriggerData.patch) at 2026-03-27 21:38:32 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (nocfbot-0001-Fixups.patch) at 2026-03-25 16:05:35 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v69-0001-Add-range_get_constructor2-to-lsyscache.patch) at 2026-03-17 14:29:07 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v68-0002-Add-UPDATE-DELETE-FOR-PORTION-OF.patch) at 2026-03-13 17:06:50 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: No)
    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)
UPDATE/DELETE FOR PORTION OF
First at 2026-10-31 17:31:51 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest at 2026-10-31 17:31:51 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest attachment (v1-0005-Allow-FOR-PORTION-OF-on-views-with-DO-ALSO-rules.patch) at 2026-10-31 17:31:51 from Paul A Jungwirth <pj at illuminatedcomputing.com>
    Attachment (v1-0005-Allow-FOR-PORTION-OF-on-views-with-DO-ALSO-rules.patch) at 2026-10-31 17:31:51 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: No)
History
When Who What
2026-10-31 22:06:39 CFbot Patch does not need rebase anymore
2026-10-31 22:02:16 Paul Jungwirth (pjungwir) Changed wikilink to https://wiki.postgresql.org/wiki/ApplicationTimeProgress
2026-10-31 22:01:46 Paul Jungwirth (pjungwir) Changed gitlink to https://github.com/pjungwir/postgresql/tree/fpo-v20
2026-10-31 22:01:15 Paul Jungwirth (pjungwir) Attached mail thread CA+renyULDQq3x-qYuADAenfqbFts9HaM66zWROZO8X+2bJf2GA@mail.gmail.com
2026-10-31 20:46:31 CFbot Patch needs rebase
2026-10-31 20:45:33 Paul Jungwirth (pjungwir) Attached mail thread ec498c3d-5f2b-48ec-b989-5561c8aa2024@illuminatedcomputing.com
2026-10-31 20:45:32 Paul Jungwirth (pjungwir) Created patch record
Edit