Re: BUG #5126: convert_to preventing index scan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5126: convert_to preventing index scan
Дата
Msg-id 1396.1256227170@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5126: convert_to preventing index scan  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: BUG #5126: convert_to preventing index scan
Список pgsql-bugs
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
>  Peter> You haven't told us how the convert_to function is defined.

> convert_to is a builtin function. If there's a bug here, it's that
> convert_to is defined as stable rather than immutable. (Sure it depends
> on server_encoding, but that can't exactly change... if there's any
> other reason why it's not immutable, I can't think what it is.)

The conversion itself is dependent on changeable catalog entries,
ie, pg_conversion.  So "stable" seems the appropriate marking to me.

            regards, tom lane

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