Foreign Key Arrays

Edit

ID 1252

Title Foreign Key Arrays

Topic SQL Commands

Created 2017-08-23 17:03:42

Last modified 2021-02-05 00:05:57 (3 years, 9 months ago)

Latest email 2021-10-05 19:15:43 (3 years, 1 month ago)

Status

2018-09: Returned with feedback

2018-07: Moved to next CF

2018-03: Moved to next CF

2018-01: Moved to next CF

2017-11: Moved to next CF

2017-09: Moved to next CF

Target version

Authors Mark Rofail (markmoheb)

Reviewers Andreas Karlsson (kandreas), Sergey Myasoedov (smyasoedov)Become reviewer

Committer Álvaro Herrera (alvherre)

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/1252
git checkout commitfest/cf/1252

Emails

GSoC 2017: Foreign Key Arrays

First at 2017-05-22 23:51:33 by Mark Rofail <markm.rofail at gmail.com>
Latest at 2021-10-05 19:15:43 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (v12-0003-fk_arrays_elems_edits.patch) at 2021-03-29 20:43:53 from Mark Rofail <markm.rofail at gmail.com>

    Attachment (v12-0003-fk_arrays_elems_edits.patch) at 2021-03-29 20:43:53 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (v11-0003-anyarray_anyelement_operators_edits.patch) at 2021-03-20 18:42:17 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (v10-0002-fk_arrays_elems.patch) at 2021-03-15 23:27:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v9-0001-anyarray_anyelement_operators.patch) at 2021-03-15 15:29:20 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (0001-anyarray_anyelement_operators.patch) at 2021-03-14 20:06:18 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v8-0001-anyarray_anyelement_operators.patch) at 2021-03-13 10:08:26 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (v7-0002-fk_arrays_elems.patch) at 2021-03-12 21:32:27 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (v6-0002-fk-arrays-elems.patch) at 2021-03-03 21:31:49 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (v5-0002-fk-arrays-elems.patch) at 2021-02-23 21:52:28 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (fk_arrays_elem_v2.patch) at 2021-02-16 10:07:10 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (type-test.sql) at 2021-02-16 07:24:50 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (anyarray_anyelement_operators-v3.patch) at 2021-02-15 19:34:54 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (type-test.sql) at 2021-02-13 11:35:34 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (anyarray_anyelement_operators-v2.patch) at 2021-02-12 19:56:42 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (fk_arrays_elem_v1.patch) at 2021-02-08 08:40:32 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (fk_arrays_elem_v1.patch) at 2021-02-07 14:10:28 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (anyarray_anyelement_operators-v1.patch) at 2021-02-05 15:27:21 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v18.patch) at 2021-02-05 00:02:53 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (fk_array_perfomance_figure.png) at 2021-02-02 12:51:18 from Mark Rofail <markm.rofail at gmail.com> (Patch: No)
    Attachment (Array-containselem-gin-v2.patch) at 2021-01-28 21:41:32 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v15.patch) at 2021-01-27 19:34:23 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v14.patch) at 2021-01-24 20:46:49 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-containselem-gin-v1.patch) at 2021-01-24 08:22:19 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v12.patch) at 2021-01-23 12:38:23 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v8.1.patch) at 2018-05-27 15:31:51 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v8.patch) at 2018-03-07 10:43:16 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v7.0.1.patch) at 2018-02-06 10:15:48 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v7.patch) at 2018-02-04 21:58:21 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v6.patch) at 2018-01-21 21:36:57 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Support-foreign-keys-for-array-elements.patch) at 2018-01-12 19:36:00 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v5.3(fixed).patch) at 2017-11-13 11:32:38 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v5.3.patch) at 2017-11-10 00:47:04 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v5.2.patch) at 2017-09-24 17:50:11 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v5.1.patch) at 2017-09-13 16:41:43 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (OriginalPatch_vs_NewPatch.diff) at 2017-08-23 17:01:18 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (FK Benchmark2.jpg) at 2017-08-21 13:43:12 from Mark Rofail <markm.rofail at gmail.com> (Patch: No)
    Attachment (Array-ELEMENT-foreign-key-v4.3.patch) at 2017-08-19 17:47:13 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v4.2.patch) at 2017-08-14 11:09:02 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v4.1.0.patch) at 2017-08-08 10:24:54 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v4 (fixed II - docs fix).patch) at 2017-07-29 19:26:51 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (FK Benchmark.jpg) at 2017-07-27 00:31:41 from Mark Rofail <markm.rofail at gmail.com> (Patch: No)
    Attachment (Array-ELEMENT-foreign-key-v4 (fixed).patch) at 2017-07-24 22:16:18 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v4.patch) at 2017-07-24 21:31:21 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (elemOperatorV4.patch) at 2017-07-24 21:08:37 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (element_foreign_key_performance.sql) at 2017-07-22 21:50:53 from Mark Rofail <markm.rofail at gmail.com> (Patch: No)
    Attachment (elemOperatorV3.4.2.patch) at 2017-07-17 23:24:09 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (GIN-fk-RI-code-v1.3.patch) at 2017-07-11 22:27:40 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (GIN-fk-RI-code-v1.1.patch) at 2017-07-08 23:35:46 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (GIN-fk-RI-code-v1.patch) at 2017-07-06 02:02:42 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v3-REBASED-42794d6.patch) at 2017-07-04 01:06:54 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (Array-ELEMENT-foreign-key-v2-REBASED-f0256c7.patch) at 2017-06-28 21:49:16 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (incomplete-Array-ELEMENT-foreign-key-v2-REBASED-ddb5fdc.patch) at 2017-06-25 23:26:31 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (elemOperatorV3_1.patch) at 2017-06-19 22:02:37 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (elemOperatorV3.patch) at 2017-06-17 21:41:28 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (elemOperatorV2.patch) at 2017-06-10 22:35:01 from Mark Rofail <markm.rofail at gmail.com> (Patch: Yes)
    Attachment (GSoCproposal2017.pdf) at 2017-05-22 23:51:33 from Mark Rofail <markm.rofail at gmail.com> (Patch: No)

Annotations

When	Who	Mail	Annotation
2017-10-30 14:28:30	Andreas Karlsson (kandreas)	From Andreas Karlsson <andreas@proxel.se> at 2017-09-18 01:55:31	Review 1
2017-10-30 14:28:42	Andreas Karlsson (kandreas)	From Andreas Karlsson <andreas@proxel.se> at 2017-10-30 01:24:06	Review 2

History

When	Who	What
2022-09-15 20:21:33	Max Panga (mpanga)	Removed mpanga from reviewers
2022-09-15 20:21:23	Max Panga (mpanga)	Added mpanga as reviewer
2022-02-21 13:04:31	Sergey Myasoedov (smyasoedov)	Added smyasoedov as reviewer
2021-02-05 00:05:57	Mark Rofail (markmoheb)	Deleted annotation "Latest Patch" from CAJvoCut_Qw3dV342Lm5uo4gWw-J2MPKKiR8Ro4aWuh-0c+eCjA@mail.gmail.com
2021-02-03 12:32:00	Mark Rofail (markmoheb)	Added annotation "Latest Patch" to CAJvoCut_Qw3dV342Lm5uo4gWw-J2MPKKiR8Ro4aWuh-0c+eCjA@mail.gmail.com
2019-10-17 18:32:13	oleg gudymenko (oleg.frontend.dev.gmail.com)	Removed oleg.frontend.dev.gmail.com from reviewers
2019-10-17 18:31:47	oleg gudymenko (oleg.frontend.dev.gmail.com)	Added oleg.frontend.dev.gmail.com as reviewer
2018-10-02 05:13:34	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Returned with feedback
2018-08-10 22:54:56	Andrew Dunstan (adunstan)	New status: Waiting on Author
2018-08-10 22:40:33	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:40:27	Andrew Dunstan (adunstan)	New status: Needs review
2018-04-10 13:48:18	David Steele (dsteele)	New status: Waiting on Author
2018-04-10 13:48:06	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-04-10 13:47:59	David Steele (dsteele)	New status: Needs review
2018-03-26 14:13:44	David Steele (dsteele)	New status: Waiting on Author
2018-03-06 22:22:58	Álvaro Herrera (alvherre)	Added alvherre as committer
2018-02-07 15:19:34	David Steele (dsteele)	Closed in commitfest 2018-01 with status: Moved to next CF
2018-02-07 03:00:56	Andreas Karlsson (kandreas)	New status: Ready for Committer
2018-01-12 20:15:14	Álvaro Herrera (alvherre)	New status: Needs review
2017-11-29 02:02:38	Michael Paquier (michael-kun)	New status: Waiting on Author
2017-11-29 02:02:34	Michael Paquier (michael-kun)	Closed in commitfest 2017-11 with status: Moved to next CF
2017-11-29 02:02:29	Michael Paquier (michael-kun)	New status: Needs review
2017-11-13 00:43:51	Andreas Karlsson (kandreas)	New status: Waiting on Author
2017-11-10 00:51:50	Mark Rofail (markmoheb)	New status: Needs review
2017-10-30 14:28:42	Andreas Karlsson (kandreas)	Added annotation "Review 2" to 76a8d3d8-a22e-3299-7c4e-6e115dbf3762@proxel.se
2017-10-30 14:28:30	Andreas Karlsson (kandreas)	Added annotation "Review 1" to 30f6433c-db7b-a732-6950-5763f1faa76f@proxel.se
2017-10-30 01:25:32	Andreas Karlsson (kandreas)	New status: Waiting on Author
2017-10-02 07:19:16	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2017-09 with status: Moved to next CF
2017-09-24 17:50:42	Mark Rofail (markmoheb)	New status: Needs review
2017-09-18 02:05:22	Andreas Karlsson (kandreas)	New status: Waiting on Author
2017-09-12 14:58:41	Aleksander Alekseev (a.alekseev)	New status: Needs review
2017-09-12 14:30:32	Aleksander Alekseev (a.alekseev)	New status: Waiting on Author
2017-09-12 00:52:28	Andreas Karlsson (kandreas)	Added kandreas as reviewer
2017-08-23 17:04:53	Mark Rofail (markmoheb)	Changed authors to Mark Rofail (markmoheb)
2017-08-23 17:03:43	Mark Rofail (markmoheb)	Attached mail thread CAJvoCut7zELHnBSC8HrM6p-R6q-NiBN1STKhqnK5fPE-9=Gq3g@mail.gmail.com
2017-08-23 17:03:42	Mark Rofail (markmoheb)	Created patch record

Edit