Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"
От
Avi Weinberg
Тема
Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"
Дата
Msg-id
AS8PR07MB7175A518D1C22D3DB14E318CCB33A@AS8PR07MB7175.eurprd07.prod.outlook.com
Список
Дерево обсуждения
Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Avi Weinberg <AviW@gilat.com>
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Tom Lane <tgl@sss.pgh.pa.us>
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" "David G. Johnston" <david.g.johnston@gmail.com>
Hi,
If you attempt to create an index based on function that is not IMMUTABLE you will get an exception "ERROR: functions in index predicate must be marked IMMUTABLE". However, if you created the index when the function was IMMUTABLE, but later on you updated the function and mistakenly removed the IMMUTABLE key, you will not get any error to alert you that there is an index based on this function and it should remain IMMUTABLE.
I suggest triggering error message also when updating a function that is used by index if it is no longer IMMUTABLE
Avi
В списке pgsql-general по дате отправления
От: Lorusso Domenico
Дата: