Mutable CHECK constraints?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Mutable CHECK constraints?
Дата
Msg-id b6182298736dceacf0ef5bde42fc5764240f78a7.camel@cybertec.at
обсуждение исходный текст
Ответы Re: Mutable CHECK constraints?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
We throw an error if the expression in a CREATE INDEX statement is not IMMUTABLE.
But while the documentation notes that expressions in CHECK constraints are not
to be immutable, we don't enforce that.  Why don't we call something like
CheckMutability inside cookConstraint?  Sure, that wouldn't catch all abuse,
but it would be better than nothing.

There is of course the worry of breaking upgrade for unsafe constraints, but is
there any other reason not to enforce immutability?

Yours,
Laurenz Albe



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Perform streaming logical transactions by background workers and parallel apply
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Time delayed LR (WAS Re: logical replication restrictions)