Re: 回复:[Internet]Re: [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 回复:[Internet]Re: [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE
Дата
Msg-id 1338896.1752088284@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 回复:[Internet]Re: [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: 回复:[Internet]Re: [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE
Список pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Wed, Jul 9, 2025 at 9:15 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> TBH, I find this proposal to be useless nannyism.

> Isn't preventing a dump-restore hazard sufficient reason to do this?

No, I don't think so.  If you're not being very careful about revising
functions used in indexes, you are going to have problems a lot sooner
than some future dump/restore cycle.

            regards, tom lane



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