Home > mailing lists

Re: [GENERAL] referential integrity between elements of an array andanother table? - Mailing list pgsql-general

From	Ken Tanzer
Subject	Re: [GENERAL] referential integrity between elements of an array andanother table?
Date	April 20, 2017 06:16:50
Msg-id	CAD3a31U-2dAeskg4FR=G=aBGPmFE9dGHQui0m1U5GfEJrOZNXQ@mail.gmail.com Whole thread Raw
In response to	Re: [GENERAL] referential integrity between elements of an array andanother table? (Henry M <henrymanmail@gmail.com>)
List	pgsql-general

Tree view

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 referential integrity in favor of the convenience. Just my two cents.

Cheers,

Ken