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

Поиск
Список
Период
Сортировка
От Henry M
Тема Re: [GENERAL] referential integrity between elements of an array andanother table?
Дата
Msg-id CAJVHaguHQd0X8gW0=o1p+0EtXHAouWqrBE3vH2xBcNy7R-4bPw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] referential integrity between elements of an array andanother table?  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: [GENERAL] referential integrity between elements of an array andanother table?
Re: [GENERAL] referential integrity between elements of an array and another table?
Список pgsql-general
Дерево обсуждения
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/9.6/static/sql-createtrigger.html that postgresql uses triggers to implement foreign keys.... so I am probably just missing the syntactic sugar for arrays. I will try to use a trigger.  Thank you.


On Wed, Apr 19, 2017 at 12:24 PM Rob Sargent <robjsargent@gmail.com> wrote:



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 is the message from the reddit poster:

Unless you have thousands of attendees per meeting and everyone in multiple meetings per day I would encourage a join table.  What's your hesitation for doing so?  Note I'm an array user myself, so not against arrays per se, but there should be a justification for denormalizing (depending your definition thereof).

В списке pgsql-general по дате отправления:

Предыдущее
От: Rj Ewing
Дата:
Сообщение: Re: [GENERAL] full text search on hstore or json with materialized view?
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: [GENERAL] referential integrity between elements of an array andanother table?