Re: BUG #5126: convert_to preventing index scan

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: BUG #5126: convert_to preventing index scan
Дата
Msg-id 87pr8fjflt.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: BUG #5126: convert_to preventing index scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #5126: convert_to preventing index scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 >> 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.)

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

That sounds like a bit of a stretch to me... we treat lots of stuff as
immutable which is actually easier to change than pg_conversion entries
(OS locale definitions for example).

--
Andrew.

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

Предыдущее
От: "Dan O'Hara"
Дата:
Сообщение: Re: BUG #5021: ts_parse doesn't recognize email addresses with underscores
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5126: convert_to preventing index scan