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

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: [GENERAL] referential integrity between elements of an array andanother table?
Дата
Msg-id 776a0fe3-f72c-d6a7-2958-7698342a45de@gmail.com
обсуждение исходный текст
Ответ на [GENERAL] referential integrity between elements of an array and another table?  (Henry M <henrymanmail@gmail.com>)
Список pgsql-general



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 по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: [GENERAL] referential integrity between elements of an array andanother table?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] referential integrity between elements of an array andanother table?