Re: [PATCH] Support for foreign keys with arrays

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Gabriele Bartolini <gabriele(dot)bartolini(at)2ndquadrant(dot)it>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it>, pgsql-hackers(at)postgresql(dot)org, Noah Misch <noah(at)leadboat(dot)com>
Subject: Re: [PATCH] Support for foreign keys with arrays
Date: 2012-07-30 16:13:51
Message-ID: CA+TgmoZKu+rU7NF=hR09BSLdJkWmvcwH18c-mq+tgiDDiCBYtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jul 30, 2012 at 11:12 AM, Gabriele Bartolini
<gabriele(dot)bartolini(at)2ndquadrant(dot)it> wrote:
> Hi guys,
>
> it is time to give another go to this patch. I would like to thank
> everyone for suggestions and ideas expressed through this list.
>
> We are happy that "Part 0" of the patch has been committed
> (array_remove() and array_replace() functions), which will be useful in
> "Part 2" (too early now to talk about it). Let's not rush though and focus
> on "Part 1" of the patch. :)
>
> First, I would like to find a unique and general term for this feature.
> We started with "Foreign keys with arrays" and ended up with "EACH foreign
> keys". Following Peter's suggestion, we will use the "ELEMENT" keyword (so
> that maybe in the future we can extend the usage). Our proposals are:
>
> * Array Foreign Key
> * Foreign Key Arrays
> * ELEMENT Foreign Keys
> * ...
>
> Which one is your favourite?

I think having the word "element" in there makes it a lot clearer.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2012-07-30 16:19:04 strange evaluation Window function and SRF functions?
Previous Message Simon Riggs 2012-07-30 15:21:46 Re: [PATCH] Support for foreign keys with arrays