Re: [HACKERS] GSoC 2017: Foreign Key Arrays

Поиск
Список
Период
Сортировка
От Mark Rofail
Тема Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Дата
Msg-id CAJvoCutFU0Hg5LD57nu_s__=sAUHOjUFp0Z4WnX2YXp1OeJqYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] GSoC 2017: Foreign Key Arrays  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
On Thu, Jul 27, 2017 at 7:30 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
Oh, ok.  I missed that.
Could you remind me why don't we have DELETE CASCADE?  I understand that UPDATE CASCADE is problematic because it's unclear which way should we delete elements from array.  But what about DELETE CASCADE?

Honestly, I didn't touch that part of the patch. It's very interesting though, I think it would be great to spend the rest of GSoC in it. 

Off the top of my head though, there's many ways to go about DELETE CASCADE. You could only delete the member of the referencing array or the whole array. I think there's a lot of options the user might want to consider and it's hard to generalize to DELETE CASCADE. Maybe new grammar would be introduced here ?|

Best Regards,
Mark Rofail

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

Предыдущее
От: Mark Rofail
Дата:
Сообщение: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [HACKERS] postgres_fdw super user checks