Re: BUG #5126: convert_to preventing index scan - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #5126: convert_to preventing index scan
Date
Msg-id 87pr8fjflt.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #5126: convert_to preventing index scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5126: convert_to preventing index scan
List 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 by date:

Previous
From: "Dan O'Hara"
Date:
Subject: Re: BUG #5021: ts_parse doesn't recognize email addresses with underscores
Next
From: Tom Lane
Date:
Subject: Re: BUG #5126: convert_to preventing index scan