From: Misa Simic <misa.simic@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
To: Gabriele Bartolini <gabriele.bartolini@2ndquadrant.it>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Marco Nenciarini <marco.nenciarini@2ndquadrant.it>
Subject: Re: [PATCH] Support for foreign keys with arrays
Date: Sun, 17 Jun 2012 13:16:55 +0200
Message-ID: <-405928980722608358@unknownmsgid> (raw)
IMO, both approaches make sense...
From temporal point no doubt, referencing should be contained by
referenced table....
From other side could be useful if in master table are elements with
simple data type, but for some set of elements there could be common
properties in another table.. What today is doable on the way to in
another table have the same data type and repeat the same properties
for each element...That would be possible with Range data type, though
it does not mean always data are in range so array is probably better
option...
However I am not sure from maintaining point of view, i,e when an
element should be removed from that common properties set - but it is
different topic :)
Kind Regards,
Misa
Sent from my Windows Phone
-----Original Message-----
From: Jeff Davis
Sent: 17/06/2012 08:55
To: Gabriele Bartolini
Cc: PostgreSQL-development; Marco Nenciarini
Subject: Re: [HACKERS] [PATCH] Support for foreign keys with arrays
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: misa.simic@gmail.com, pgsql@j-davis.com, gabriele.bartolini@2ndquadrant.it, marco.nenciarini@2ndquadrant.it
Subject: Re: [PATCH] Support for foreign keys with arrays
In-Reply-To: <-405928980722608358@unknownmsgid>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox