Re: 2 questions about volatile attribute of pg_proc.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 2 questions about volatile attribute of pg_proc.
Дата
Msg-id 428542.1618760165@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 2 questions about volatile attribute of pg_proc.  (Andy Fan <zhihui.fan1213@gmail.com>)
Ответы Re: 2 questions about volatile attribute of pg_proc.
Список pgsql-hackers
Andy Fan <zhihui.fan1213@gmail.com> writes:
> We know volatile is very harmful for optimizers and it is the default
> value (and safest value) if the user doesn't provide that.  Asking user
> to set the value is not a good experience,  is it possible to auto-generate
> the value for it rather than use the volatile directly for user defined
> function. I
> think it should be possible, we just need to scan the PlpgSQL_stmt to see
> if there
> is a volatile function?

Are you familiar with the halting problem?  I don't see any meaningful
difference here.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bogus collation version recording in recordMultipleDependencies
Следующее
От: Isaac Morland
Дата:
Сообщение: Re: 2 questions about volatile attribute of pg_proc.