Re: Check-out mutable functions in check constraints

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Check-out mutable functions in check constraints
Дата
Msg-id CAFj8pRCY=gUKik9-DfABgcsDzJf2iYOsTpO8fkWs+X1NFYtgUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Check-out mutable functions in check constraints  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Ответы Re: Check-out mutable functions in check constraints  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
Hi

pá 12. 7. 2019 v 8:45 odesílatel Kyotaro Horiguchi <horikyota.ntt@gmail.com> napsal:
Hello.

As mentioned in the following message:

https://www.postgresql.org/message-id/20190712.150527.145133646.horikyota.ntt%40gmail.com

Mutable function are allowed in check constraint expressions but
it is not right. The attached is a proposed fix for it including
regression test.

Other "constraints vs xxxx" checks do not seem to be exercised
but it would be another issue.

I think so this feature (although is correct) can breaks almost all applications - it is 20 year late.

Regards

Pavel


regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Check-out mutable functions in check constraints
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Memory-Bounded Hash Aggregation