Foreign Key Arrays

Edit

ID 2966

Title Foreign Key Arrays

Topic SQL Commands

Created 2021-02-03 12:30:12

Last modified 2021-09-14 18:59:01 (3 years, 2 months ago)

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

Status

2021-09: Returned with feedback

2021-07: Moved to next CF

2021-03: Moved to next CF

Target version

Authors Mark Rofail (markmoheb)

Reviewers Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby)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/2966
git checkout commitfest/cf/2966

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
2021-09-14 18:59:01	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-03 02:52:59	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-08-03 02:51:29	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:51:26	Masahiko Sawada (masahikosawada)	New status: Needs review
2021-07-14 15:50:25	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2021-04-08 15:50:18	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-03-15 16:32:03	Justin Pryzby (justinpryzby)	Added justinpryzby as reviewer
2021-03-15 16:32:01	Justin Pryzby (justinpryzby)	New status: Needs review
2021-02-23 22:27:33	Justin Pryzby (justinpryzby)	New status: Waiting on Author
2021-02-17 09:42:01	Joel Jacobson (joeljacobson)	Posted review with messageid <161355492179.24325.7368484308828752659.pgcf@coridan.postgresql.org>
2021-02-17 09:42:01	Joel Jacobson (joeljacobson)	New status: Ready for Committer
2021-02-12 19:56:50	Mark Rofail (markmoheb)	New status: Needs review
2021-02-12 17:01:50	Joel Jacobson (joeljacobson)	New status: Waiting on Author
2021-02-10 20:40:55	Joel Jacobson (joeljacobson)	Added joeljacobson as reviewer
2021-02-08 12:18:34	Álvaro Herrera (alvherre)	Changed authors to Mark Rofail (markmoheb)
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 15:00:42	Mark Rofail (markmoheb)	Attached mail thread CAJvoCut7zELHnBSC8HrM6p-R6q-NiBN1STKhqnK5fPE-9=Gq3g@mail.gmail.com
2021-02-03 15:00:27	Mark Rofail (markmoheb)	Detached mail thread CAJvoCut7zELHnBSC8HrM6p-R6q-NiBN1STKhqnK5fPE-9=Gq3g@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
2021-02-03 12:30:18	Mark Rofail (markmoheb)	Changed topic to SQL Commands
2021-02-03 12:30:12	Mark Rofail (markmoheb)	Attached mail thread CAJvoCut7zELHnBSC8HrM6p-R6q-NiBN1STKhqnK5fPE-9=Gq3g@mail.gmail.com
2021-02-03 12:30:12	Mark Rofail (markmoheb)	Created patch record

Edit