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 ago)
Latest email 2021-10-05 19:15:43 (3 years 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