Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"
Дата
Msg-id 20230711.163029.2291239725090453767.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
At Mon, 10 Jul 2023 21:28:12 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote in 
> In the end, adding such restrictions would just give a false sense
> of security, because there would always be gaps in whatever we did.
> As you quote from the documentation, volatility markings are a promise
> by the user to the system, not vice versa.  If you break your promise,
> you get to keep both pieces of whatever trouble ensues.

I agree to you, as I mentioned a-bit-too-late message..

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Gurjeet Singh
Дата:
Сообщение: Re: how to return data from insert into ... on conflict ... returning ... into
Следующее
От: KK CHN
Дата:
Сообщение: BI Reports and Postgres