SQL:2011 application time

Edit

ID

Title

SQL:2011 application time

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 0, First patch: +0−0, All patches: +0−0

Topic

SQL Commands

Tags

Created

2025-03-20 15:31:54

Last modified

2025-06-22 23:37:26 (4 months ago)

Latest email

2025-06-02 13:50:45 (4 months ago)

Status

PG19-1 (2025-07-01 – 2025-07-31): Committed

Target version

Authors

Paul Jungwirth (pjungwir)

Reviewers

Become reviewer

Committer

Peter Eisentraut (petere)

Links

Emails

SQL:2011 application time: First at 2021-06-30 17:39:00 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest at 2025-06-02 13:50:45 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (0001-WIP-Rename-gist-stratnum-support-function.patch) at 2025-05-26 05:57:19 from Peter Eisentraut <peter at eisentraut.org>
    Attachment (0001-WIP-Rename-gist-stratnum-support-function.patch) at 2025-05-26 05:57:19 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v51-0002-Add-UPDATE-DELETE-FOR-PORTION-OF.patch) at 2025-05-08 16:20:06 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v50-0001-Add-without_portion-GiST-support-proc.patch) at 2025-03-20 03:32:38 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v49-0001-Remove-support-for-temporal-RESTRICT-foreign-key.patch) at 2025-02-26 05:15:43 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (0001-WIP-Fix-RESTRICT-behavior-for-temporal-foreign-keys.patch.nocfbot) at 2025-02-13 13:23:25 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v48.0-0001-Trigger-the-RESTRICT-build-farm-failures-consis.patch.nocfbot) at 2025-01-29 06:34:33 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v48-0001-Add-without_portion-GiST-support-proc.patch) at 2025-01-11 23:19:26 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v47-0001-Document-strange-jsonb-sort-order-for-empty-top-.patch) at 2025-01-04 21:39:26 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v46-0001-Add-without_portion-GiST-support-proc.patch) at 2025-01-03 01:47:02 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v45.3-0001-Improve-internal-logical-replication-e.patch.nocfbot) at 2024-12-07 19:29:33 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v45.2-0001-Improve-internal-logical-replication-error-for.patch) at 2024-12-04 11:15:40 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (0001-Simplify-IsIndexUsableForReplicaIdentityFull.patch.nocfbot) at 2024-11-26 12:18:07 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v45-0001-Fix-logical-replication-for-temporal-tables.patch) at 2024-11-22 00:30:06 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v44-0001-Fix-logical-replication-for-temporal-tables.patch) at 2024-11-15 06:38:47 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v43-0001-Add-WITHOUT-OVERLAPS-and-PERIOD-to-ALTER-TABLE-r.patch) at 2024-10-31 16:18:44 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v42-0001-Add-WITHOUT-OVERLAPS-and-PERIOD-to-ALTER-TABLE-r.patch) at 2024-10-25 00:22:32 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v41-0001-Add-WITHOUT-OVERLAPS-and-PERIOD-to-ALTER-TABLE-r.patch) at 2024-10-21 21:46:14 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v40-0003-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch) at 2024-10-13 05:25:40 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v39-0001-refactor-tests.no-cfbot) at 2024-08-16 02:12:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v39-0001-Add-stratnum-GiST-support-function.patch) at 2024-08-07 20:54:52 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v38-0001-Add-stratnum-GiST-support-function.patch) at 2024-08-01 17:09:03 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v37-0001-Add-stratnum-GiST-support-function.patch) at 2024-07-25 15:52:44 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v36-0001-Add-stratnum-GiST-support-function.patch) at 2024-07-18 18:39:09 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-forbid-empty-range-value-for-period-column.patch) at 2024-07-09 07:15:39 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Add-stratnum-GiST-support-function.patch) at 2024-07-05 19:22:31 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v34-0001-Add-stratnum-GiST-support-function.patch) at 2024-06-27 21:56:15 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (0001-Revert-Fix-ON-CONFLICT-DO-NOTHING-UPDATE-for-tempora.patch) at 2024-05-15 09:39:47 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v3-0001-Don-t-treat-WITHOUT-OVERLAPS-indexes-as-unique-in.patch) at 2024-05-13 00:51:41 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v2-0001-Fix-ON-CONFLICT-DO-NOTHING-UPDATE-for-temporal-in.patch) at 2024-05-09 04:24:09 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v4-0001-add-a-special-check-constrint-for-PERIOD-primary-.patch) at 2024-05-06 03:01:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-ON-CONFLICT-DO-NOTHING-UPDATE-for-temporal-in.patch) at 2024-04-30 16:39:24 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-Fix-ON-CONFLICT-DO-NOTHING-UPDATE-for-temporal-in.patch) at 2024-04-03 05:30:20 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v33-0001-Add-temporal-FOREIGN-KEYs.patch) at 2024-03-23 17:42:47 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v32-0001-minor-refactor-temporal-FKs-with-multiranges-.no-cfbot) at 2024-03-22 05:33:37 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Add-temporal-FOREIGN-KEYs.patch) at 2024-03-22 00:35:53 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v31-0001-refactor-temporal-FKs-with-multiranges-regressio.no-cfbot) at 2024-03-21 08:25:15 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Add-temporal-FOREIGN-KEYs.patch) at 2024-03-20 16:21:44 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v30-0001-Add-temporal-FOREIGN-KEYs.patch) at 2024-03-20 04:03:44 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v29-0001-Use-daterange-and-YMD-in-tests-instead-of-tsrang.patch) at 2024-03-18 22:49:28 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v28-0001-refactor-transformFkeyGetPrimaryKey-for-bette.no-cfbot) at 2024-03-18 04:47:18 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v28-0004-Add-GiST-referencedagg-support-func.patch) at 2024-03-16 21:37:10 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (0001-fixup-Add-temporal-FOREIGN-KEYs.patch.nocfbot) at 2024-03-11 07:46:16 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v27-0001-Rename-conwithoutoverlaps-to-conperiod.patch) at 2024-03-01 21:56:16 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v26-0001-Rename-conwithoutoverlaps-to-conperiod.patch) at 2024-03-01 20:38:27 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v25-0001-Rename-conwithoutoverlaps-to-conperiod.patch) at 2024-02-29 21:16:56 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-refactor-temporal-FOREIGN-KEYs-test.patch) at 2024-02-02 05:53:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-refactor-temporal-FOREIGN-KEYs-test.based_on_v24) at 2024-01-29 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Fix-comment-on-gist_stratnum_btree.patch) at 2024-01-24 22:06:56 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v23-0001-Add-stratnum-GiST-support-function.patch) at 2024-01-18 03:59:06 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-minor-refactor.no-cfbot) at 2024-01-14 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (Screenshot from 2024-01-08 11-09-50.png) at 2024-01-09 00:00:00 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v22-0001-Add-stratnum-GiST-support-function.patch) at 2024-01-06 00:19:53 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v21-0001-Add-stratnum-GiST-support-function.patch) at 2024-01-02 01:59:47 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v20-0001-Add-stratnum-GiST-support-function.patch) at 2023-12-31 08:51:49 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-set eval targetrange in per-output-tuple context.patch) at 2023-12-06 13:22:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-12-02 18:11:52 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v18-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-11-17 18:39:58 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (0001-fixup-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraint.patch.nocfbot) at 2023-11-09 13:47:12 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v17-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-11-02 20:21:37 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v1-0001-various-small-fixes.patch) at 2023-10-30 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-refactor-findNewOrOldColumn.patch) at 2023-10-25 06:14:34 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-refactor-function-range_leftover_internal.patch) at 2023-10-23 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-09-25 20:20:59 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v15-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-09-20 02:50:10 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v14-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-09-14 16:11:02 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v13-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-08-31 21:26:31 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v12-0002-fixup-Add-temporal-PRIMARY-KEY-and-UNIQU.patch.nocfbot) at 2023-07-12 08:24:45 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (v12-0001-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2023-07-07 01:03:37 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (0001-fixup-Add-PERIODs.patch) at 2023-05-08 07:10:09 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (v11-0004-Add-temporal-FOREIGN-KEYs.patch) at 2023-05-03 21:02:47 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v10-0001-Add-PERIODs.patch) at 2021-11-21 01:51:16 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v9-0001-Add-PERIODs.patch) at 2021-11-16 23:55:26 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v8-0001-Add-PERIODs.patch) at 2021-09-13 04:12:19 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v7-0002-Add-temporal-PRIMARY-KEY-and-UNIQUE-constraints.patch) at 2021-09-06 19:52:37 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v6-0001-Add-PERIODs-compile-errors.log) at 2021-09-04 19:55:56 from Jaime Casanova <jcasanov at systemguards.com.ec> (Patch: No)
    Attachment (v6-0001-Add-PERIODs.patch) at 2021-07-03 17:46:55 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v5-0001-Add-PERIODs.patch) at 2021-07-02 21:39:50 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)
    Attachment (v4-0001-Add-PERIODs.patch) at 2021-06-30 17:39:00 from Paul A Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)

History

When	Who	What
2025-06-22 23:37:26	Paul Jungwirth (pjungwir)	Closed in commitfest PG19-1 with status: Committed
2025-06-22 23:37:25	Paul Jungwirth (pjungwir)	Changed committer to petere
2025-05-22 21:19:53	CFbot	Patch does not need rebase anymore
2025-05-21 20:35:39	CFbot	Patch needs rebase
2025-05-16 14:10:48	CFbot	Patch does not need rebase anymore
2025-05-14 13:49:42	CFbot	Patch needs rebase
2025-05-08 18:01:48	CFbot	Patch does not need rebase anymore
2025-03-31 07:20:46	CFbot	Patch needs rebase
2025-03-20 15:31:55	Paul Jungwirth (pjungwir)	Attached mail thread CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com
2025-03-20 15:31:54	Paul Jungwirth (pjungwir)	Created patch record

Edit