From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Henry M <henrymanmail(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: referential integrity between elements of an array and another table? |
Date: | 2017-04-19 19:25:12 |
Message-ID: | d7208d9a-8393-b5cc-14d7-8255159cc915@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 can think of is a faux FK, a INSERT/UPDATE trigger that
verifies that the ids in the array are in the person table.
>
>
> ----- below is the message from the reddit poster:
>
> https://www.reddit.com/r/PostgreSQL/comments/66a74t/question_referential_integrity_between_elements/
>
> First off, thanks for taking the time. I don't see any "weekly help
> threads" or anything so I hope it's okay I made a post.
>
> /The Problem/
>
> I'm extending our CRM database in order to manage the ISO documentation
> of the company for which I work. We need, as part of ISO, to keep track
> of project development meetings and attendees.
>
> Currently, I have a "meetings" table with an attendee list as an array
> of integers, each element corresponding to the id field in the "person"
> table.
>
> How do I enforce referential integrity between elements of this array
> and the id field in "person"? All I could find was a proposed change for
> 9.2 or 9.3 that got shot down...
>
> Please help. I don't want to do a join table.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2017-04-19 20:13:08 | Re: UDP buffer drops / statistics collector |
Previous Message | Rob Sargent | 2017-04-19 19:24:09 | Re: referential integrity between elements of an array and another table? |