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

 

 

 

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Lorusso Domenico
Дата:
FAQ