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

Поиск

Список

Период

Сортировка

От	Ken Tanzer
Тема	Re: Need to check each element of an array satisfies a foreign key constraint
Дата	13 июля 2021 г. 19:44:46
Msg-id	CAD3a31V6ohctaCHBEvr9TKVf=DH0JOhM4Pm-hYf+VS490W==eg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Need to check each element of an array satisfies a foreign key constraint (David Gauthier <davegauthierpg@gmail.com>)
Список	pgsql-general

Дерево обсуждения

On Tue, Jul 13, 2021 at 7:47 AM David Gauthier <davegauthierpg@gmail.com> 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