SQL:2011 application time

Edit

ID 2048

Title SQL:2011 application time

Topic SQL Commands

Created 2019-03-01 04:52:34

Last modified 2022-02-07 03:18:15 (2 years, 9 months ago)

Latest email 2024-11-15 06:38:47 (6 days, 1 hour ago)

Status

2022-01: Returned with feedback

2021-11: Moved to next CF

2021-09: Moved to next CF

2021-07: Moved to next CF

2020-09: Moved to next CF

2020-07: Moved to next CF

2020-03: Moved to next CF

2020-01: Moved to next CF

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

2019-03: Moved to next CF

Target version

Authors Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar)

Reviewers Peter Eisentraut (petere)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2048
git checkout commitfest/cf/2048

Emails

SQL:2011 application time: First at 2021-06-30 17:39:00 by Paul A Jungwirth <pj at illuminatedcomputing.com>
Latest at 2024-11-15 06:38:47 by Paul Jungwirth <pj at illuminatedcomputing.com>
Latest attachment (v44-0001-Fix-logical-replication-for-temporal-tables.patch) at 2024-11-15 06:38:47 from Paul Jungwirth <pj at illuminatedcomputing.com>
    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
2022-02-07 03:18:15	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Returned with feedback
2022-01-15 05:59:03	Julien Rouhaud (rjuju)	New status: Waiting on Author
2021-12-01 10:34:45	Peter Eisentraut (petere)	Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-21 06:11:00	Paul Jungwirth (pjungwir)	New status: Needs review
2021-10-01 07:01:08	Michael Paquier (michael-kun)	New status: Waiting on Author
2021-10-01 07:01:03	Michael Paquier (michael-kun)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-31 17:30:53	Peter Eisentraut (petere)	Added petere as reviewer
2021-08-03 02:31:32	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-19 17:53:08	Ibrar Ahmed (ibrar)	Detached mail thread CA+renyUb+XHzsrPHHR6ELqguxaUPGhOPyVc7NW+kRsRpBZuUFQ@mail.gmail.com
2021-07-15 14:30:26	Paul Jungwirth (pjungwir)	Changed name to SQL:2011 application time
2021-07-15 14:29:57	Paul Jungwirth (pjungwir)	New status: Needs review
2021-07-15 13:20:49	Ibrar Ahmed (ibrar)	New status: Waiting on Author
2021-06-30 17:43:07	Paul Jungwirth (pjungwir)	Closed in commitfest 2020-09 with status: Moved to next CF
2021-06-30 17:41:10	Paul Jungwirth (pjungwir)	New status: Needs review
2021-06-30 17:40:59	Paul Jungwirth (pjungwir)	Attached mail thread CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com
2021-04-08 14:22:25	David Steele (dsteele)	Closed in commitfest 2020-09 with status: Returned with feedback
2020-10-27 14:16:53	Ibrar Ahmed (ibrar)	Changed name to SQL:2011 PERIODS vs Postgres Ranges?
2020-10-27 14:15:10	Ibrar Ahmed (ibrar)	Added annotation "New patch based on (0525572860335d050a1bea194a5278c8833304d1)" to CALtqXTeJXQCb-ZEKazw8o51OmOujkaOQo6OkNQNOgtc0bzv3kg@mail.gmail.com
2020-10-27 14:14:07	Ibrar Ahmed (ibrar)	New status: Needs review
2020-10-27 14:13:14	Ibrar Ahmed (ibrar)	Changed authors to Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar)
2020-10-27 14:12:47	Ibrar Ahmed (ibrar)	Removed ibrar from reviewers
2020-09-30 07:38:10	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Returned with feedback
2020-09-17 07:49:11	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-08-03 20:46:00	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 16:14:02	David Steele (dsteele)	Changed targetversion to None
2020-04-08 15:40:14	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:58:17	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-28 04:12:52	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-28 04:12:16	Michael Paquier (michael-kun)	New status: Needs review
2019-09-30 19:11:07	Álvaro Herrera (alvherre)	New status: Waiting on Author
2019-09-30 19:09:32	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-30 19:08:55	Álvaro Herrera (alvherre)	New status: Needs review
2019-08-02 20:51:13	Ibrar Ahmed (ibrar)	Added annotation "Latest Patch Set" to CALtqXTcfVNbWfRKQKiEsKy-F0yQFzqwA+gHf_c6UrxVEa3YvMw@mail.gmail.com
2019-08-02 20:28:23	Ibrar Ahmed (ibrar)	Posted comment with messageid <156477770335.1401.7738145215865735767.pgcf@coridan.postgresql.org>
2019-08-02 20:28:23	Ibrar Ahmed (ibrar)	New status: Waiting on Author
2019-08-01 10:22:02	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-08-01 10:21:58	Thomas Munro (macdice)	New status: Needs review
2019-07-26 13:34:30	Ibrar Ahmed (ibrar)	Posted comment with messageid <156414807043.1401.3879256194189252684.pgcf@coridan.postgresql.org>
2019-07-26 13:34:30	Ibrar Ahmed (ibrar)	New status: Waiting on Author
2019-04-06 20:43:24	David Steele (dsteele)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-05 08:33:00	David Steele (dsteele)	Changed authors to Paul Jungwirth (pjungwir)
2019-03-05 08:33:00	David Steele (dsteele)	Changed targetversion to 13
2019-03-04 19:59:28	Ibrar Ahmed (ibrar)	Added ibrar as reviewer
2019-03-01 04:52:34	Paul Jungwirth (pjungwir)	Attached mail thread CA+renyUb+XHzsrPHHR6ELqguxaUPGhOPyVc7NW+kRsRpBZuUFQ@mail.gmail.com
2019-03-01 04:52:34	Paul Jungwirth (pjungwir)	Created patch record

Edit