Re: NOT ENFORCED constraint feature

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: NOT ENFORCED constraint feature
Дата
Msg-id
acef3c5e-0731-45af-a709-25cfd8fbc0e8@eisentraut.org
Ответ на
Re: NOT ENFORCED constraint feature (Ashutosh Bapat)
Список
Дерево обсуждения
Re: NOT ENFORCED constraint feature Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: NOT ENFORCED constraint feature Amul Sul <sulamul@gmail.com>
Re: NOT ENFORCED constraint feature Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: NOT ENFORCED constraint feature Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: NOT ENFORCED constraint feature Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: NOT ENFORCED constraint feature Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: NOT ENFORCED constraint feature Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: NOT ENFORCED constraint feature Peter Eisentraut <peter@eisentraut.org>
Re: NOT ENFORCED constraint feature Peter Eisentraut <peter@eisentraut.org>
Re: NOT ENFORCED constraint feature Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: NOT ENFORCED constraint feature Peter Eisentraut <peter@eisentraut.org>
Re: NOT ENFORCED constraint feature Amul Sul <sulamul@gmail.com> 
On 03.02.25 06:19, Ashutosh Bapat wrote:
> Here's how I see the state conversions happening.
> 
> NOT VALID, NOT ENFORCED changed to NOT_VALID, ENFORCED - no data
> validation required, constraint is enforced on the new tuples/changes
> NOT VALID, ENFORCED changed to NOT VALID, NOT ENFORCED - no data
> validation, constraint isn't enforced anymore
> VALID, NOT ENFORCED changed to VALID, ENFORCED - data validation
> required, constraint is enforced
> VALID, ENFORCED changed to VALID, NOT ENFORCED - no data validation
> required, constrain isn't enforced anymore, we rely on user to enforce
> the constraint on their side

This looks sensible to me.
В списке pgsql-hackers по дате отправления
Предыдущее
От: Alena Rybakina
Дата:
Следующее
От: Peter Eisentraut
Дата:
FAQ