Foreign Key Arrays

Edit

Title

Foreign Key Arrays

Topic

SQL Commands

Created

2017-08-23 17:03:42

Last modified

2021-02-05 00:05:57 (3 years, 2 months ago)

Latest email

2021-10-05 19:15:43 (2 years, 6 months 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

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