Re: Optimising Foreign Key checks

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Optimising Foreign Key checks
Дата
Msg-id CAM-w4HNNoUp0PR10bzmj1=pbUvAioGqwJ3QTztT6wkvt2iLjKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimising Foreign Key checks  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Optimising Foreign Key checks  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On Sun, Jun 9, 2013 at 10:51 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> AFAICS there are weird cases where changing the way FKs execute will
> change the way complex trigger applications will execute. I don't see
> a way to avoid that other than "do nothing". Currently, we execute the
> checks following the normal order of execution rules for triggers.
> Every idea we've had so far changes that in some way; variously in
> major or minor ways, but changed nonetheless.

The obvious case to handle would be if someone has a trigger to
automatically create any missing references.


-- 
greg



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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Batch API for After Triggers
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Vacuum, Freeze and Analyze: the big picture