Re: [GENERAL] UPDATE column without FK fires other FK triggers constraint check

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] UPDATE column without FK fires other FK triggers constraint check
Дата
Msg-id 2782.1500502476@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL] UPDATE column without FK fires other FK triggers constraint check  (Luca Looz <luca.looz92@gmail.com>)
Список pgsql-general
Luca Looz <luca.looz92@gmail.com> writes:
> Thanks for the explanation!
> Can these checks be implemented or the data needed is not there and adding
> it will only add an overhead for the majority of use cases?

It's hard to see how to do much better than we're doing without storing
more data on-disk than is there now.  Whether that would be a good
tradeoff is dubious.

            regards, tom lane


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

Предыдущее
От: Evan Martin
Дата:
Сообщение: Re: [GENERAL] Why would log_lock_waits affect a query plan?
Следующее
От: Matthew Byrne
Дата:
Сообщение: Re: [GENERAL] Support for \u0000?