Re: Need to check each element of an array satisfies a foreign key constraint

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

On Tue, Jul 13, 2021 at 7:47 AM David Gauthier <davegauthierpg@xxxxxxxxx> wrote:

Ok, thanks. 

I was looking for, but didn't find, something like... each_element_of(regexp_split_to_array(children_csv)) references projects(project);

Of course the "each_element_of" is my creation here :-)

Several years ago, I had hopes for this, and still do.  It would be great for my use cases.  From what I remember, it was "complicated."  There was a patch proposed at least as far back as 9.3 for this[1].    Googling for this now though, I see there was some activity on it this year[2].  Does anyone know the status of this, or if/when this is likely to show up in Postgresql?  Thanks!

Ken

1. https://www.2ndquadrant.com/en/blog/postgresql-9-3-development-array-element-foreign-keys/

2. https://www.postgresql-archive.org/GSoC-2017-Foreign-Key-Arrays-td5962835i140.html

 

--

AGENCY Software  

A Free Software data system

By and for non-profits

http://agency-software.org/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.