Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Tom Lane
Henry M writes: > No hesitation. I am just trying to understand the options. This blog seemed > to indicate the functionality existed but it looks like it was never > completed ( > https://blog.2ndquadrant.com/postgresql-9-3-development-array-element-foreign-keys/ > ). Yeah, there was a patch lik

Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Ken Tanzer
For me, foreign keys for arrays would be incredibly helpful. For simple checkbox-type options, it's _much_ simpler to just put them in an array, and I work with a UI that can handle the arrays well. I do hope this makes it into Postgresql someday! In the meantime, I've mostly sacrificed the refe

Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Henry M
No hesitation. I am just trying to understand the options. This blog seemed to indicate the functionality existed but it looks like it was never completed ( https://blog.2ndquadrant.com/postgresql-9-3-development-array-element-foreign-keys/ ). I see in this document https://www.postgresql.org/docs

Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Adrian Klaver
On 04/19/2017 12:13 PM, Henry M wrote: I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you. The only thing I

Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Rob Sargent
On 04/19/2017 01:13 PM, Henry M wrote: I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you. - below

Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Rob Sargent
On 04/19/2017 01:13 PM, Henry M wrote: I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you. - below

[GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Henry M
I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you. - below is the message from the reddit poster: https