Foreign Key Arrays

Edit

Title

Foreign Key Arrays

Topic

SQL Commands

Created

2021-02-03 12:30:12

Last modified

2021-09-14 18:59:01 (8 months, 1 week ago)

Latest email

2021-10-05 19:15:43 (7 months, 3 weeks 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

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	vignesh 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